Hi, any advice is welcome but a solution is preferred, I joke :D
I can't seem to remove the shapes from new workbooks after they have been created???
Thanks.Please Login or Register to view this content.
Hi, any advice is welcome but a solution is preferred, I joke :D
I can't seem to remove the shapes from new workbooks after they have been created???
Thanks.Please Login or Register to view this content.
Sorry I should have mention I have a userform which check boxes on it, the idea is to select which 'reports' you want and then those selected get created into new, separate, workbooks. This is not a problem, but I can't then remove the shapes from the sheets that are copied into the new workbooks.
This is a personal project to help teach myself.
Have you stepped through the code, in particular the sub resetSheet, with F8?
If posting code please use code tags, see here.
I can honestly say no. I wondering if it has something to do with which workbook is or becomes the active workbook?
If you step through the code you might find out which workbook/sheet(s) the code in the sub resetSheet is acting on.
Another thing, it might be acting on the correct workbook/sheet(s) but might not be dealing with the 'correct' shapes/objects.
Sometimes, if you change shapes data you have to force. Try putting that line at the very end of resetSheet.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I had copy/paste some code so it kept activating the same workbook, lesson learned - always write the code!
I've sorted it now thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks