Copying sheet through Button

[khan_imran]

Hello All,

I have a requirement to copy entire sheet through a click on the button. After performing the task if I come back on the original sheet and do some changes to it, then there will not be any impact on copied sheet. If again perform the copy of a sheet, it will create another sheet.

This action I want to perform 6 times. all the copied sheet must carry the selection which was there while copying the sheet.

I tried doing alternate state but could able to do so. Is there any macro through which i can copy the sheet and detach it?

Regards,

Imran Khan

[vinieme12]

No you cannot do that

Create your copies and 6 different states for each sheet and assign the new state to each object manually