Avoid Prompts on Workbook open?

J

J.W. Aldridge

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
 
N

Neptune Dinosaur

JW

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top