davedave24
Programmer
Hi all
I'm trying to move 2 sheets from the master document into a new document, save as, and close, with no input from the user (file names, folder etc.)
The 2 sheets have several buttons with code on. When I try to copy the sheet over, it retains the buttons and code. I've attempted to use DrawingObjects.Delete to remove the buttons, but the code remains.
Is there an easy way to do this, while retaining all the source formatting, removing the buttons and code, and saving without the user being prompted?
Thanks
I'm trying to move 2 sheets from the master document into a new document, save as, and close, with no input from the user (file names, folder etc.)
The 2 sheets have several buttons with code on. When I try to copy the sheet over, it retains the buttons and code. I've attempted to use DrawingObjects.Delete to remove the buttons, but the code remains.
Is there an easy way to do this, while retaining all the source formatting, removing the buttons and code, and saving without the user being prompted?
Thanks