| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid Prompts on Workbook open?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Avoid Prompts on Workbook open?
JW
We'd need to see what is in your WorkBook_Open routine. Can you post it for us? -- Time is just the thing that keeps everything from happening all at once "J.W. Aldridge" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file prompts: open or save? | Excel Discussion (Misc queries) | |||
| how do I get prompts to either open or save a download? | Excel Discussion (Misc queries) | |||
| Avoid prompts with QueryTables | Excel Programming | |||
| How to avoid opening an empty workbook every time I open a file? | Setting up and Configuration of Excel | |||
| How do you avoid window that prompts to enable auto query refresh | Excel Discussion (Misc queries) | |||
Linear Mode
