View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Hidden worksheet

You can't select a hidden worksheet, but you don't need to

Private Sub CommandButton1_Click()
Unload UserForm3
UserForm2.Show
Module3.Fill_ID_Down Sheets("Engraving Jobs")
End Sub

Change the Fill_ID_Down code to accept a worksheet reference and work with
that sheet without selecting it.

--
Regards,
Tom Ogilvy


"Patrick Simonds" wrote in message
...
Why wont the following code work on a hidden worksheet? UserForm2 will be
used to place data on the hidden worksheet.


Private Sub CommandButton1_Click()
Unload UserForm3
Sheets("Engraving Jobs").Select
Range("A1").Select
UserForm2.Show
'Module3.Fill_ID_Down
End Sub