I have an application that adds worksheets as required by the user. This includes various graphics objects etc using the following code:
This works fine, however, it does not copy the macros from the source sheet such as :Please Login or Register to view this content.
As you can see, the macros themselves are just calls to the actual routines in a VBA module.Please Login or Register to view this content.
Also what needs to be copied are some custom properties such as:
What is the best way of achieving a complete clone of the worksheet including all macros etc?Please Login or Register to view this content.
Regards
Rich
Bookmarks