Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Locking a column
microsoft excel courses - Locking a column
Resolved · Low Priority · Version Standard
Laura has attended:
Access Introduction course
Excel Intermediate course
Locking a column
How do I hide and lock one or more columns without locking the whole sheet. I know with hide that the person can then simply unhide so I need a way to lock the columns and make them untouchable?
For upcoming training course dates see: Pricing & availability
RE: Locking a column
Hi Laura
Once you have hidden the column, simpy put a password on the sheet
TOOLS > PROTECTION > PROTECT SHEET
add a password
verify password
When you do this, the other user will not be able to make a modification to the sheet, unless they have your password.
Regards
Richard
|
