LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Increment Cell Value on Worksheet Change

Hi,

In cell B3, I have a worksheet version number that starts with 1.

Various people view, edit and print the file. I would like the version
number to increment by 1 each time the worksheet is opened and changes are
made.

Perhaps triggered upon open and the person can either view and not keep
changes to cancel the incrementation, or make changes and save to keep it?

Any help would be greatly appreciated!
 
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 to increment page number in a cell of worksheet Zubair Excel Discussion (Misc queries) 2 February 5th 10 01:46 PM
change formula- keep cell increment sheet numbers Ali Excel Discussion (Misc queries) 3 March 24th 09 09:31 AM
how to make a cell value increment every time a new worksheet is o mabari Excel Programming 1 June 30th 08 07:06 PM
Change Cell from Validated List Not Firing Worksheet Change Event [email protected] Excel Programming 3 October 4th 04 03:00 AM
Increment row change by two hotherps[_11_] Excel Programming 1 February 17th 04 08:29 PM


All times are GMT +1. The time now is 02:19 AM.

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"