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 update column with weekdays

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
Column Chart Update automatically for all worksheets? TJAC Charts and Charting in Excel 1 May 5th 07 09:22 PM
Creating a year of weekdays automatically? waterskyle Excel Programming 5 January 6th 06 07:24 PM
Automatically update column - Autofill poppy Excel Programming 0 October 7th 04 02:15 PM
Automatically update column - Autofill poppy Excel Programming 0 October 6th 04 08:33 AM
Automatically update column - Autofill poppy Excel Programming 1 October 5th 04 02:43 PM


All times are GMT +1. The time now is 01:22 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"