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

M

marq

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

Thanks,
Mar
 
J

John P

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
 
Top