Delete Buttons made from shapes when copying sheet to new workbook

[Bflare]

Hello,

I have a code that copies a sheet into a new workbook. The copied sheet is for information only. On the original sheet I have various macro's assigned to buttons made from using Insert Shape command. I assume if I can find away to remove the buttons then the functionality of the macro's would be lost which is what I want??

Thanks,

Tony.

[cytop]

Your current code would help...

In the absence of - and assuming you have a reference to the copied sheet and you want to delete all shapes:

Please Login or Register  to view this content.

If there's nothing to call the procedures then that would do what you want - however the code will remain in the workbook unless you also save it as a XLSX file.

[Bflare]

Your current code would help...

In the absence of - and assuming you have a reference to the copied sheet and you want to delete all shapes:

Please Login or Register  to view this content.

If there's nothing to call the procedures then that would do what you want - however the code will remain in the workbook unless you also save it as a XLSX file.

Hi Cytop,

My code is as follows:

Please Login or Register  to view this content.

Thanks,

Tony.

[cytop]

Then simply the following in each block for VDS & VCD (Only one shown below)

Please Login or Register  to view this content.

[Bflare]

Then simply the following in each block for VDS & VCD (Only one shown below)

Please Login or Register  to view this content.

Hi Cytop,

Sorry but I do not understand?

[cytop]

what do you not understand?

[Bflare]

what do you not understand?

Hi Cytop,

I do not understand where I need to place

Please Login or Register  to view this content.

Also the statement "Move this to the top of the procedure as is the usual convention..."

[cytop]

The convention is that variables are declared at the top of a procedure, so move the declaration for s up to where you declare other variables,

The code sample is shown in situ for one of your worksheets named VDSxxx, I'd presume you want to do the same for the other worksheet called VCD. Simply copy the code to the appropriate place for that sheet.

[Bflare]

The convention is that variables are declared at the top of a procedure, so move the declaration for s up to where you declare other variables,

The code sample is shown in situ for one of your worksheets named VDSxxx, I'd presume you want to do the same for the other worksheet called VCD. Simply copy the code to the appropriate place for that sheet.

You mean as the following:

Please Login or Register  to view this content.

If so I am getting an error??

[Bflare]

Hi Cytop,

I do not understand where I need to place

Please Login or Register  to view this content.

Also the statement "Move this to the top of the procedure as is the usual convention..."

Cytop,

Yaayyyyy thanks I have managed to do it. I only required it not to copy the shapes on the VCS sheet. The code I used was:

Please Login or Register  to view this content.

I have highlighted the text in red that I used.

Thank you again