Macro / Programming to lock cells

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

Hello, I would appreciate any help with this issue.

I have an excel sheet and need certain cells to be locked down which isn't a
problem, I need the users to be able to add comments to the locked down
cells, is this possible?

Thanks.

Neil.
 
Hi Neil

Yes you can by allowing 'Objects' to be edited when you apply your worksheet
protection.

Regards,

Lee
 

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

Locking Cells 2
Scope priviledges for locked/unlocked cells 2
Locked cells are still able to be selected with proper protection 1
How to lock the selected cells in 2007 4
copy cells but lock editing 5
macro to unlock and lock cells in password protected sheet 3
Locked cells tabbing? 2
Enabling Autofilter and Sorting in a Protected Sheet 2

Back
Top