-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copying button and event
- Thread starter jcg31
- Start date
Datsmart
Well-known Member
- Joined
- Jun 19, 2003
- Messages
- 7,985
Sounds like you are using a Controls Toolbox button. You will have to re-build the click event code with each copy you do.
The easy solution would be to use a Forms button. Then the code copies with the button.
-or-
If you don't like the drab look of the Forms button, you can use a Drawing Toolbar Shape (I like the Bevel shape), and assign it to a macro. You can add color, shadow, etc. as desired. When you copy it, all the properties, including the code, copy with it just like a Forms button.
The easy solution would be to use a Forms button. Then the code copies with the button.
-or-
If you don't like the drab look of the Forms button, you can use a Drawing Toolbar Shape (I like the Bevel shape), and assign it to a macro. You can add color, shadow, etc. as desired. When you copy it, all the properties, including the code, copy with it just like a Forms button.
Upvote
0
