Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Avoid Prompts on Workbook open?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J.W. Aldridge - 23 May 2008 13:19 GMT
I have a workbook that I built that has macros in it. I recently
posted it to the web, but each time its opened by someone it asks
twice if they want to save the changes, and once if they want to run
the macros etc.

is there any way via code to avoid either or both of these prompts? It
is kinda annoying to have to answer these questions over and over
again each time someone wants to open the workbook.

Thanx
Neptune Dinosaur - 29 May 2008 02:39 GMT
JW

We'd need to see what is in your WorkBook_Open routine.  Can you post it for
us?

Signature

Time is just the thing that keeps everything from happening all at once

> I have a workbook that I built that has macros in it. I recently
> posted it to the web, but each time its opened by someone it asks
[quoted text clipped - 6 lines]
>
> Thanx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.