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
|