SeanJ
08-13-2008, 05:13 AM
Hi again,
I have created a workbook that on open shows a form with a button. I am trying to program the button to add a sheet to the workbook. This part I am having issues with I get "run time error 1004". After the first sheet is created and the next time I open the book I want bypass the added new sheet and view all sheet. :banghead: :dunno
rivate Sub cmdGotoSheet_Click()
Dim newsheet As Worksheet
Set wks = Worksheets.Add
End Sub
What in the world am I doing wrong.
PS I want to figureout how to bypass the add new sheet first before coming to you guys for help.
I have created a workbook that on open shows a form with a button. I am trying to program the button to add a sheet to the workbook. This part I am having issues with I get "run time error 1004". After the first sheet is created and the next time I open the book I want bypass the added new sheet and view all sheet. :banghead: :dunno
rivate Sub cmdGotoSheet_Click()
Dim newsheet As Worksheet
Set wks = Worksheets.Add
End Sub
What in the world am I doing wrong.
PS I want to figureout how to bypass the add new sheet first before coming to you guys for help.