Button
 

Hi

Is there a way to copy a button(with code) from one
worksheet into another worksheet....using code?

Thanks in advance

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