Unprotecting a Comment

  • Thread starter Thread starter michele
  • Start date Start date
M

michele

Hi,

I have a protected sheet in Excel 2003 and the cell with the comment in
it that I'm try to unprotect is unlocked, but I still can't edit or
delete the comment. I'm just checking 'select locked cells' and
'select unlocked cells' when protecting the sheet. If I uncheck
'select unlocked cells' then 'select locked cells' unchecks, too. I
can't unprotect the sheet as other cells need to be protected.

I tried Tools>Protection>Allow Users To Edit Ranges, but it appears
that I need to add the permission I made to a group or username. Since
I'm making this spreadsheet for my customer, I'm not sure what his
username is. He's running Windows XP Pro with Office 2003. Is there a
standard username I should use and will this work?

Thanks,

Michele
 
The comment is an object in the worksheet--not unlike a shape or button dropped
onto the sheet.

When you protect the sheet, you can allow users access to the comment (and other
objects) by:

Tools|Protect|Protect worksheet|
at the bottom of the xl2003 dialog, there's an "Edit Objects" checkbox.

Turn that on and you'll be able to edit the comment.
 
Back
Top