I'd like to know how to protect hidden rows or columns in a worksh

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

Guest

so the users cannot unhide them but at the same time allowing them to edit
the rest of the worksheet.

Thanks,
Mar
 
Protect the cells you dont want touching and hide them then allow the others
to be unprotected.

See Format Cells protection to identify cells for locking and then Tools
Protection to do the job.

Cheers

John
North Yorkshire
 
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

hide, unhide column or row after protect worksheet 4
Problem with hidden rows automatically unhiding 2
Cannot unhide the hidden rows in my spreadsheet 3
Prevent unhiding columns 1
Why do hidden columns/rows unhide automatically? 1
hidden column 1
How can I reveal hidden column and row headings on screen? 3
Protect sheet but hide rows? 7

Back
Top