Thread: opening a worksheet with a command button on a form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gbpg gbpg is offline
external usenet poster
  
Posts: 58
Default opening a worksheet with a command button on a form
The following sub produces an error 9
any ideas..is it because it is in a seperate form?

Sub Button1_Click()
Worksheets("Sheet1").Activate
End Sub

Reply With QuoteReply With Quote