Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Comments from deletion
Hi
I have set up a spreadsheet using the worksheet change command so that when a user changes the data in a cell the font changes colour and a comment is added to say who made the change and when. I don't want the users to be able to delete the comment because I need to record it. Is there any way of doing this. Worksheet protection is not an option in this case. Any help would be gratefully received. Thanks Aehan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Comments from deletion
Don't use comments. Use a hidden sheet and write the information to the
corresponding cell. -- Regards, Tom Ogilvy "aehan" wrote: Hi I have set up a spreadsheet using the worksheet change command so that when a user changes the data in a cell the font changes colour and a comment is added to say who made the change and when. I don't want the users to be able to delete the comment because I need to record it. Is there any way of doing this. Worksheet protection is not an option in this case. Any help would be gratefully received. Thanks Aehan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect worksheet but allow row deletion | Excel Worksheet Functions | |||
Protect files from deletion | Excel Discussion (Misc queries) | |||
Protect worksheet from deletion | Excel Discussion (Misc queries) | |||
protect a file from deletion | Excel Discussion (Misc queries) | |||
Prevent deletion Comments | Excel Programming |