Change notice
 

When the button to close my spread sheet is pushed, it
returns you to the switchboard, but has a yes/no of:
"Do you want to save the changes etc..."

I need this to say "Always choose NO CHANGES". I still
need the thing to come up, because I make changes, but I
want my users to see the never change message. How do I
do this?
Thank you,
Gee...

Change notice
 

Is it closed with code. If so, try

ActiveWorkbook.Close savechanges:=False


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gee..." wrote in message
...
When the button to close my spread sheet is pushed, it
returns you to the switchboard, but has a yes/no of:
"Do you want to save the changes etc..."

I need this to say "Always choose NO CHANGES". I still
need the thing to come up, because I make changes, but I
want my users to see the never change message. How do I
do this?
Thank you,
Gee...