Hi.
Working with a macro enabled workbook that has many sheets what would be a good code that would save Sheet1 into a new MACRO enabled workbook so that the 'Buttons' (which are linked to macros) on this specific sheet will be the only macros that will be copied to the new workbook as opposed to the rest of the macros that are found in different sheets?
It sounds easy but I can't get it to work.
Here is what I g=have:
Please Login or Register to view this content.
Last edited by kosherboy; 01-28-2014 at 05:28 PM.
Please Login or Register to view this content.
Last edited by G e r a r d; 01-28-2014 at 05:44 PM.
Thanks! It worked but the macros are based off the old workbook and so the macro doesn't work. Is there a way to make it work for the new workbook?
Put the macro in the Sheet1 in stead of a module
How do I do that?
In the IDE project explorer ( Ctrl + R) you find the Sheet1, click on it so it opens. Place the macro there.
Hi. I think there is some progress. I did what you said and the code is now found in the new sheet, however, the problem now is that the 'button' on the new sheet does not link to the code?
Maybe posting a workbook example can bring some light to your problem.
TEST-1.xlsm
Thank you.
Use activex button, then it will work see mod attachment
TEST-1.xlsm
Seemed to have worked pretty good. How do I assign an activex button?
I got it! Thanks for all you help. Everything is now working smoothly.
I'm really thankful to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks