Button

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

Hi

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

Thanks in advance
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
How to use multiple command button to copy user form data to multiple worksheet 0
Code to copy worksheet 5
Command Button Question 8
How to enable "Links" when copy a worksheet (with buttons on it) to anew book 2
VBA - Importing Sheets 18
How to change add-in object from within worksheet module. 3
Option Private Module (for Object Modules) 5

Back
Top