PDA

View Full Version : Solved: Entering Cell Comments On A Protected Worksheet



BENSON
05-30-2007, 12:04 AM
Hi Guys ,is it possible to allow users to be able to enter cell comments on a protected work sheet.if so could you please let me know how.

Thks

geekgirlau
05-31-2007, 08:31 PM
You would have to provide a macro to do this: prompt user for their comment text, unprotect the sheet, create the comment, then protect the sheet again.

BENSON
05-31-2007, 10:07 PM
Thanks for the advice