grimlock
New Member
- Joined
- Mar 9, 2009
- Messages
- 39
Thank you in advance for reading and offering your input, I really appreciate it.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Excel Version: 2007
VBA Experience: limited
I am trying to create a simple macro: Copy "Template" worksheet and create a copy named "PCO 1". The macro will be triggered by a button. After the button is pressed and the macro is run I would like to automatically delete the button.<o></o>
Thanks!<o></o>
<o></o>
A bit more info on what I am trying to accomplish:<o></o>
I intend to have 100 of these buttons on a main page, there purpose it to create a new PCO "Proposed Change Order". They will be done in order from one to a max of 100. (Perhaps there is a better way to do this, with one button that creates a new "PCO" and adds a number based on what is existing?)
<o></o>
Excel Version: 2007
VBA Experience: limited
I am trying to create a simple macro: Copy "Template" worksheet and create a copy named "PCO 1". The macro will be triggered by a button. After the button is pressed and the macro is run I would like to automatically delete the button.<o></o>
Thanks!<o></o>
<o></o>
A bit more info on what I am trying to accomplish:<o></o>
I intend to have 100 of these buttons on a main page, there purpose it to create a new PCO "Proposed Change Order". They will be done in order from one to a max of 100. (Perhaps there is a better way to do this, with one button that creates a new "PCO" and adds a number based on what is existing?)