Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think that I have done exactly as described, in an empty worksheet,
assuming that the instructions were exact and complete. After saving the workbook and reopening it I get the following error:- Run-time error '424' Object required What am I doing wrong? Do the instructions omit some detail that I am assumed to know? What should I expect to see? Thanks for any help Brian Tozer cornishbloke wrote: to run a macro upon opening a workbook you need to create a macro in the 'ThisWorkbook' object (see top left of VB Editor screen and double click 'ThisWorkbook'). e.g. to show a userform upon opening I have used the following: Private Sub Workbook_Open() Quote_Details.Show End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Macro Automatically When Excel 2003 Opens | Excel Discussion (Misc queries) | |||
Auto adding a macro when Excel 2003 opens | Excel Discussion (Misc queries) | |||
Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
Runnig macros in background mode | Excel Programming | |||
Runnig macros in background mode | Excel Programming |