LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You could make a userform with your notes on it.
Debra Dalgleish has some notes for userforms at:
http://www.contextures.com/xlUserForm01.html

Then create a subroutine in a general module named auto_open

Option Explicit
Sub Auto_Open()
userform1.show
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Auto_Open will run each time that the workbook is opened (with macros enabled).

coal_miner wrote:

Greetings, I have a worksheet that I wont to have a dialog box/window popup
when someone opens it giving them directions to operate my pivotreport. How
can I do this? Can I have it so it pops up before anything else does?
Thanks in advance. Cheers


--

Dave Peterson
 
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
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM
Template in Excel prettytwin1 New Users to Excel 1 March 9th 05 09:22 PM
Excel's Dialog Box Dialog Box Excel Discussion (Misc queries) 1 February 12th 05 12:53 PM
Using the "Go To" dialog for "Copy" Fred Holmes Excel Discussion (Misc queries) 0 January 20th 05 06:40 PM
trying to create Lost in reconcillation Excel Discussion (Misc queries) 2 December 19th 04 01:05 AM


All times are GMT +1. The time now is 12:33 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"