Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to protect a cell after entering formula. But at the same time the entire worksheet except that cell should be unprotected/Open for edit.

Kindly suggest solution for the same.
 
Hi,

It's easy. Select all the cells you want to allow
access, Ctl-click on the cell you wish to protect.
Go to menu, format>cells choose Protection,
uncheck "locked". and OK.

you're done.

jeff

-----Original Message-----
I want to protect a cell after entering formula. But at
Click to expand...
the same time the entire worksheet except that cell
should be unprotected/Open for edit.
 
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

Cell protection after entering formula. 2
How to protect a single cell in worksheet. 2
Protection on Worksheets 5
hide, unhide column or row after protect worksheet 4
Refreshing Pivot Table on a protected spreadsheet tab 1
Can't access cells 2
Need help with macro to copy, paste, and clear cell values 8
Protect and Unprotect all worksheets with macro 2

Back
Top