Adding Comments in a Protected Worksheet (2007 beta)

  • Thread starter Thread starter Darrell \(Singapore\)
  • Start date Start date
D

Darrell \(Singapore\)

Hi,

How can I add comments to a protected worksheet (office 2007 beta).

Darrell
 
anyone know how to do this?

when I protect the worksheet, I cannot add any comments.

Darrell
 
Hi Darrell,
Record a macro turning off protection,
make the changes
turn protection back on, Stop recording macro

If a password is required that will have been recorded when you
record the macro. Keep in mind that security in Excel is aimed
at preventing accidental removal. Of course each version claimns
more than previous versions.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Worksheets and Comments 1
WorkSheet Protection problem 1
Add comments in a protected sheet 2
The Worksheet was created in an earlier beta version of Excel 2007 - Problem Office 2007 & Vista RTM 1
inserting comments on protected cells 1
XL2007: Protection and Name Manager? 1
Add comment in protected worksheet 3
protecting worksheet corrupts file 1

Back
Top