LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Runnig a macro when excel opens

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Macro Automatically When Excel 2003 Opens CBender Excel Discussion (Misc queries) 2 May 7th 10 05:25 PM
Auto adding a macro when Excel 2003 opens gigabyteconsulting Excel Discussion (Misc queries) 4 July 6th 09 08:57 PM
Excel file opens and opens and opens Wanna Learn Excel Discussion (Misc queries) 1 June 9th 09 11:03 PM
Runnig macros in background mode Tom Ogilvy Excel Programming 0 August 6th 03 06:49 PM
Runnig macros in background mode Chip Pearson Excel Programming 0 August 6th 03 06:47 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"