Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modification history
I want to design a spreadsheet with an automated means to
record the timestamp when each of the different worksheets within the spreadsheet are modified. I would suppose that the BeforeSave and WorkSheetSelectionChange events need to be used in combination. However, WorkSheetSelectionChange event would be trigerred everything something is modified; and thus could give me an incorrect picture; for example: if I change something on a worksheet and UnDo it then my simple routine would still record it as a change. I would like this modification history table to be built only if the worksheet has really changed in contents with reference to its previously saved version. In that situation only do I want a record to be added; also it needs to be only one record per worksheet for each SAVE and not every time the worksheet is changed. Anybody has any ideas? Many thanks in anticipation, Akshay. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modification history
To be that precise, you would need to record the state of the worksheet(s)
at the start, then make a comparison when the save is done to see if there is a difference. Sounds like a lot of overhead. Then if you find a difference, write your record. This comparison and writing would be done in the before save event. You would then update your record of the "starting position" -- Regards, Tom Ogilvy "Akshay Bakhai" wrote in message ... I want to design a spreadsheet with an automated means to record the timestamp when each of the different worksheets within the spreadsheet are modified. I would suppose that the BeforeSave and WorkSheetSelectionChange events need to be used in combination. However, WorkSheetSelectionChange event would be trigerred everything something is modified; and thus could give me an incorrect picture; for example: if I change something on a worksheet and UnDo it then my simple routine would still record it as a change. I would like this modification history table to be built only if the worksheet has really changed in contents with reference to its previously saved version. In that situation only do I want a record to be added; also it needs to be only one record per worksheet for each SAVE and not every time the worksheet is changed. Anybody has any ideas? Many thanks in anticipation, Akshay. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modification history
I am assuming you have explored the history feature associated with the
Shared Workbook option under the data menu. -- Regards, Tom Ogilvy "Akshay Bakhai" wrote in message ... I want to design a spreadsheet with an automated means to record the timestamp when each of the different worksheets within the spreadsheet are modified. I would suppose that the BeforeSave and WorkSheetSelectionChange events need to be used in combination. However, WorkSheetSelectionChange event would be trigerred everything something is modified; and thus could give me an incorrect picture; for example: if I change something on a worksheet and UnDo it then my simple routine would still record it as a change. I would like this modification history table to be built only if the worksheet has really changed in contents with reference to its previously saved version. In that situation only do I want a record to be added; also it needs to be only one record per worksheet for each SAVE and not every time the worksheet is changed. Anybody has any ideas? Many thanks in anticipation, Akshay. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modification history
Tom
I have not explored the history feature. I will try that out to see if I can put it to some use. thanks a lot for the help akshay -----Original Message----- I am assuming you have explored the history feature associated with the Shared Workbook option under the data menu. -- Regards, Tom Ogilvy "Akshay Bakhai" wrote in message ... I want to design a spreadsheet with an automated means to record the timestamp when each of the different worksheets within the spreadsheet are modified. I would suppose that the BeforeSave and WorkSheetSelectionChange events need to be used in combination. However, WorkSheetSelectionChange event would be trigerred everything something is modified; and thus could give me an incorrect picture; for example: if I change something on a worksheet and UnDo it then my simple routine would still record it as a change. I would like this modification history table to be built only if the worksheet has really changed in contents with reference to its previously saved version. In that situation only do I want a record to be added; also it needs to be only one record per worksheet for each SAVE and not every time the worksheet is changed. Anybody has any ideas? Many thanks in anticipation, Akshay. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code modification help | Excel Worksheet Functions | |||
Macro Modification Help | Excel Discussion (Misc queries) | |||
macro - modification | Excel Discussion (Misc queries) | |||
last modification | Excel Discussion (Misc queries) | |||
text modification | Excel Worksheet Functions |