I currently have a command button that will copy and export the active worksheet to a new file with a specific naming convention for saving. However, I want the same button which appears in the new file to be repurposed when that file is opened. Is there a way to make either a new button appear in this instance based on the different file name or to have this one change purpose after having run once?
Last edited by Tobre; 01-26-2011 at 10:36 AM.
You could build a test into the beginning of the macro that looks at the filename and does something different if the filename is anything other than the original template name.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I have done this with command buttons and have the macro code check the caption of the command button to with an if statement to determine which code to run.
This could be modified to your needs and would not revert back to the origial CommandButton's functionality if you don't rename it in the second if statement.
Please Login or Register to view this content.
I have also used a shape (ie. rectangle) with text as a button and after it was clicked the last few lines of the code would delete the original rectangle then add a new rectangle, the text I want it to contain and assign it's 'OnAction' property to call the desired macro when it is clicked.
This second method is a little more involved but could also be used for your purposes.
The wbname test would go along the lines of:
Please Login or Register to view this content.
Thank you very much. It was such a brilliantly simple solution. Worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks