Easy question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How Can i get a command button that when i hit that creates a new sheet in my
workbook???


Much thanks!!
 
If you want the really easy way you should just add the "Worksheet"
toolbutton to the toolbar of your choice. If you don't know how to do it
manually here's code that adds it to the Standard toolbar:

Sub AddWorksheetToolBtn()
CommandBars("Standard").Controls.Add , 852
End Sub
 
How Can i get a command button that when i hit that creates a new sheet in my
workbook???

Much thanks!!
Click to expand...

Add a button, write macro and link that macro with that button.
Hope that helps.
Aqib Rizvi
 
Hi,

If you use the terminology "Command Button", then do the following:

1. On the View menu, point to Toolbars, and then click the Control Toolbox.
The Control Toolbox toolbar is displayed.
2. Click the Command Button icon. The cursor changes to "+" pointer. The
first icon in the Control Toolbox displays that you are in the design mode.
3. Click on the Worksheet, and drag diagonally to specify the size of the
button.
4. The Command button is place on the worsheet with the labe.
"CommandButton1".
5. Right-click on the Command button, ans select viewcode. The Microsoft
Visual basic design mode opens, with the Code view for that button. Write the
Click event procedure for this command button. and then to the worksheet.
6. Right-click the Commandbutton and set the Properties.
7. On the Control Toolbox, click the first icon in the Toolbar to exit the
Design mode and return to the runtime mode.

Note: Unless you write an event for this command button to perform what task
you want to do after clicking, you will not be able to perform any action,
whether you are in design mode or runtime mode.

Challa Prabhu
 
Back
Top