This forum has been outstanding in helping me with my workbook. I need a macro to respond to a button click event that creates a copy of the worksheet, "TEMPLATE." It should land inside the same workbook, complete with all of "TEMPLATE"'s charts and formulas. Much appreciated.
I kept searching and found this which does what I want, but I would like to add to it. It'd be nice to have a mesage box come up asking for a name to put into the new worksheet tab and then to have it automatically alphabetize itself.
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Great! Totally beyond what I can do with vba right now.
One problem is that when I hit "cancel" it gives me a runtime 1004 error message.
The part I have in yellow is actually highlighted in yellow in the module. When I right click and go to "definition," it says that it "cannot jump to 'ActiveSheet' because it is hidden."Please Login or Register to view this content.
Also, how could you make cell A2 match what is put into the message box? That is, cell A2 should match what is said on the worksheet tab.
Moderator's Note: As per Forum Rule #12, don't quote whole posts unless necessary-- it's just clutter...Thanks.
Last edited by jeffreybrown; 12-07-2012 at 09:03 PM.
That's weird - is it hidden??? - Try this:
Please Login or Register to view this content.
Last edited by xladept; 12-07-2012 at 09:03 PM.
No, I don't have it hidden. It's a workbook I am working on at my job, not at home. I'll try it out on Monday, thanks for the follow up.
Works great, thank you!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks