View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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