| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open workbook
Is there anything wrong with this code?
When I open the workbook, it should activate sheet "menu", but I keep getting a run-time error 57121 with application and object defined error with it. Private Sub Workbook_Open() Worksheets("menu").Select Worksheets("menu").CommandButton3.Visible = False UserForm8.Show End Sub any ideas? -- capt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open workbook
You may want to search google for that error code. Maybe something will pop up
that can help. But in the meantime, how about trying to qualify those worksheets: Private Sub Workbook_Open() me.Worksheets("menu").Select me.Worksheets("menu").CommandButton3.Visible = False UserForm8.Show End Sub capt wrote: Is there anything wrong with this code? When I open the workbook, it should activate sheet "menu", but I keep getting a run-time error 57121 with application and object defined error with it. Private Sub Workbook_Open() Worksheets("menu").Select Worksheets("menu").CommandButton3.Visible = False UserForm8.Show End Sub any ideas? -- capt -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open workbook
Thanks Dave that sorted the problem.
-- capt "Dave Peterson" wrote: You may want to search google for that error code. Maybe something will pop up that can help. But in the meantime, how about trying to qualify those worksheets: Private Sub Workbook_Open() me.Worksheets("menu").Select me.Worksheets("menu").CommandButton3.Visible = False UserForm8.Show End Sub capt wrote: Is there anything wrong with this code? When I open the workbook, it should activate sheet "menu", but I keep getting a run-time error 57121 with application and object defined error with it. Private Sub Workbook_Open() Worksheets("menu").Select Worksheets("menu").CommandButton3.Visible = False UserForm8.Show End Sub any ideas? -- capt -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
| Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
