Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment command
I have a 'Protected and Shared' workbook that a group of colleagues and
myself use at work. Problem: I want to make the 'Insert Comment' function invalid. I want it only to become valid on clicking a programmed button on my sheet. This will then allow a comment to be inserted. After the comment has been inserted, the function will once again become invalid. Q. Can you offer any advice? Thanks in anticipation Russ Stevens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment command
If you protect objects as part of your protection, then you can't insert
comments. In your code, unprotect the sheet, add the comment, reprotect the sheet. How sharing the workbook affects this scenario, I can't say although I know sharing imposes a lot of restrictions. -- Regards, Tom Ogilvy Russell Stevenson wrote in message om... I have a 'Protected and Shared' workbook that a group of colleagues and myself use at work. Problem: I want to make the 'Insert Comment' function invalid. I want it only to become valid on clicking a programmed button on my sheet. This will then allow a comment to be inserted. After the comment has been inserted, the function will once again become invalid. Q. Can you offer any advice? Thanks in anticipation Russ Stevens |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment command
Maybe you can use this option
You can protect the worksheet (ToolsProtectionProtect Sheet) and check "Edit Objects" They can edit all objects this way!! -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom Ogilvy" wrote in message ... If you protect objects as part of your protection, then you can't insert comments. In your code, unprotect the sheet, add the comment, reprotect the sheet. How sharing the workbook affects this scenario, I can't say although I know sharing imposes a lot of restrictions. -- Regards, Tom Ogilvy Russell Stevenson wrote in message om... I have a 'Protected and Shared' workbook that a group of colleagues and myself use at work. Problem: I want to make the 'Insert Comment' function invalid. I want it only to become valid on clicking a programmed button on my sheet. This will then allow a comment to be inserted. After the comment has been inserted, the function will once again become invalid. Q. Can you offer any advice? Thanks in anticipation Russ Stevens |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment command
Sorry
I see Tom mention it already about the protection option -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom Ogilvy" wrote in message ... If you protect objects as part of your protection, then you can't insert comments. In your code, unprotect the sheet, add the comment, reprotect the sheet. How sharing the workbook affects this scenario, I can't say although I know sharing imposes a lot of restrictions. -- Regards, Tom Ogilvy Russell Stevenson wrote in message om... I have a 'Protected and Shared' workbook that a group of colleagues and myself use at work. Problem: I want to make the 'Insert Comment' function invalid. I want it only to become valid on clicking a programmed button on my sheet. This will then allow a comment to be inserted. After the comment has been inserted, the function will once again become invalid. Q. Can you offer any advice? Thanks in anticipation Russ Stevens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert comment | Excel Discussion (Misc queries) | |||
Insert Comment Command | Excel Discussion (Misc queries) | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
paste command not work in 'comment' | Excel Discussion (Misc queries) | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) |