Unprotecting a Comment

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.

michele@quality-computing.com wrote:
>
> 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

--

Dave Peterson