| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Worksheet Beyond Column Z
I have protected my Workseet but for some reason, all the columns starting
with AA will not protect? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Worksheet Beyond Column Z
Hi,
For protection to work the cells must be locked. Select the coluns and Format|Cells - protection tab and ensure locked is checked Mike "Kiley" wrote: I have protected my Workseet but for some reason, all the columns starting with AA will not protect? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Worksheet Beyond Column Z
The cells are locked.....
"Mike H" wrote: Hi, For protection to work the cells must be locked. Select the coluns and Format|Cells - protection tab and ensure locked is checked Mike "Kiley" wrote: I have protected my Workseet but for some reason, all the columns starting with AA will not protect? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Worksheet Beyond Column Z
Unprotect the sheet.
Ctrl + a(twice in XL2003) to select all sheet cells. FormatCellsProtection............set to "locked" Now protect the sheet. Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 09:51:04 -0700, Kiley wrote: The cells are locked..... "Mike H" wrote: Hi, For protection to work the cells must be locked. Select the coluns and Format|Cells - protection tab and ensure locked is checked Mike "Kiley" wrote: I have protected my Workseet but for some reason, all the columns starting with AA will not protect? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting worksheet | Excel Worksheet Functions | |||
| Protecting 1 Worksheet within a Workbook | Setting up and Configuration of Excel | |||
| Un-Protecting a Worksheet | Excel Discussion (Misc queries) | |||
| protecting the worksheet | Excel Worksheet Functions | |||
| Protecting Worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
