LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default WorkbookOpen

I've tried using the help files, and the knowledge base,
but I can't figure out how to make this work.

I've got a simple macro that I would like to run everytime
a particular workbook is opened. It's just a routine that
updates a query, and then refreshes a corresponding pivot
table. It does this for 13 different queries and tables.
I've got a macro that works fine, but I don't know how to
make it run automatically when the workbook is opened.

I don't understand class modules, application events, or
any of this stuff that I've been reading. Please help!

Thanks.
 
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
Open Find Dialog at WorkbookOpen Rob Excel Discussion (Misc queries) 3 September 22nd 09 06:56 AM
Unprotecting 4 sheets before "WorkbookOpen" macro runs kcdonaldson Excel Discussion (Misc queries) 1 December 7th 05 02:21 PM
workbookopen doesn't function P Westerman via OfficeKB.com Excel Discussion (Misc queries) 0 February 6th 05 05:13 PM
WorkbookOpen() Auto macro Richard[_19_] Excel Programming 1 October 10th 03 03:17 PM


All times are GMT +1. The time now is 07:26 PM.

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

About Us

"It's about Microsoft Excel"