Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question
How Can i get a command button that when i hit that creates a new sheet in my
workbook??? Much thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question
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 -- Jim "M&M" wrote in message ... How Can i get a command button that when i hit that creates a new sheet in my workbook??? Much thanks!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question
On Aug 10, 8:00 pm, M&M wrote:
How Can i get a command button that when i hit that creates a new sheet in my workbook??? Much thanks!! Add a button, write macro and link that macro with that button. Hope that helps. Aqib Rizvi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question
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 "M&M" wrote: How Can i get a command button that when i hit that creates a new sheet in my workbook??? Much thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy VBA question | Excel Discussion (Misc queries) | |||
Easy Question | Excel Discussion (Misc queries) | |||
Easy Question | Excel Worksheet Functions | |||
Easy question for you all | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |