Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button
Hi
Is there a way to copy a button(with code) from one worksheet into another worksheet....using code? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button
There are 2 kinds of buttons in Excel that you cn add.
1. From the Forms menu. This button is ideal for your situation. This button copies with the sheet and is attached to code within a module. Each copy of the button is active and will call the procedure in the module. 2. From the Control Toolbox. This button is more familiar as the standard VB button with properites and such. Code created for this button is embedden in the sheet on which it is placed. If the sheet is copied the code does not go with it and the button does nothing. "JC" wrote: Hi Is there a way to copy a button(with code) from one worksheet into another worksheet....using code? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo button and redo button quit | Excel Discussion (Misc queries) | |||
Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming |