suppressing "do you want to save changes..."
If you know, absolutely, that you never want a user to be prompted to "save
changes" add this code to the ThisWorkbook module of the workbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Saved = True
End Sub
--
Jim
"Ken" wrote in message
oups.com...
I recentely started to get prompted "Do you want to save the changes to
*.xls?" regardless of whether or not I made any changes. I have many
users who now receive the prompt for files that they did not even know
they had opened. Those are hidden files that contain code and data
that are opened via an add-in that I wrote and people have used for
years without even being aware the hidden files even existed. I believe
this just started happening with a server upgrade (to 2003). Does
anyone know of a setting somewhere that could be set to always prompt
for saving changes, even when no changes were made? Or, alternatively,
is there something I could put in the code to suppress that warning on
certain files?
Thanks
Ken
|