Need help with locking columns
Al,
Try this. Select all cells by clicking the box above the 1 of row 1. Right
click anywhere on the sheet
Format Cells - Protection Tab and un-check 'Locked' - OK
Select your 3 columns by holding down CTRL and clicking on the column header
of each column
Right click in one of the selected columns and repeat the formatting but
this time check 'Locked' - OK
Protect the sheet and your done.
Mike
"Al" wrote:
I am trying to lock columns A, F, and H on Sheet1 so that when a user opens
the workbook, these 3 columns are locked for any editing, however, I want the
user to be able to edit any thing else on the sheet. I need help with the
code.
thanks
Al
|