View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Add comment in a protected sheet, Excel 2000

Mats,
You would need to give the user some userform/inputbox to enter their
comment, .Unprotect the sheet, add/edit the comment in which cell, .Protect
the sheet.

NickHk

"Mats Nilsson" ...
Hi everybody,
In Excel 2003 a user can add comment in a protected sheet, if editing
objects is allowed. I have to make it possible also in Excel 2000 with VBA
code. I¡¦m thinking of using a userform with textbox but maybe there is
some
better way.
Thanks in advance for any suggestion.
Best Regards
Mats
--
ESI Update