Thread: Easy question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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!!