LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Automatically save workbook when exiting

Hi all,

I have created a workbook that records the user name, date and time the
workbook was opened in a hidden worksheet, but as it is updated it asks
the user whether to save the workbook of the changes or not before exiting.

I would like the workbook to automatically save ONLY the hidden
worksheet without offering an option to the user. If the user has
modified any other worksheets of the workbook then I would like to
follow the protocol of asking the user to save the complete workbook. At
all times, the hidden worksheet must be save without question every time
the workbook is exited.

Is this possible?

Thanx in advance

Maddoktor
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I disable save prompt when exiting a sheet? Copter32 Excel Discussion (Misc queries) 7 March 12th 08 04:25 PM
HOW DO YOU GET EXCEL TO ASK IF YOU WANT TO SAVE A FILE ON EXITING David Lambright Excel Discussion (Misc queries) 3 October 15th 05 07:46 AM
IS THERE A SETTING TO DISABLE SAVE ON EXITING? Leo Excel Discussion (Misc queries) 5 September 9th 05 03:07 PM
Exiting WorkBook Save event Richard Buttrey Excel Programming 3 July 29th 05 06:23 PM
Exiting Excel prompts for save MXH Excel Discussion (Misc queries) 3 February 22nd 05 08:31 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"