| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet protection and cell fomat changes
Hi Folks,
i have a macro which automatically protects all the sheets in a workbook. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="my password here" Next ws but i need to allow users the aboloty to change the format options of any cells even if they are locked. any help is greatly appreciated. thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet protection and cell fomat changes
ws.Protect Password:="password", AllowFormattingCells:=True,
AllowFormattingColumns:=True, AllowFormattingRows:=True "Stephen" wrote: Hi Folks, i have a macro which automatically protects all the sheets in a workbook. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="my password here" Next ws but i need to allow users the aboloty to change the format options of any cells even if they are locked. any help is greatly appreciated. thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet protection and cell fomat changes
you rock!
thanks! "Vergel Adriano" wrote: ws.Protect Password:="password", AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True "Stephen" wrote: Hi Folks, i have a macro which automatically protects all the sheets in a workbook. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="my password here" Next ws but i need to allow users the aboloty to change the format options of any cells even if they are locked. any help is greatly appreciated. thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet protection and cell fomat changes
What version of Excel are you using? Your code may help me solve my issue.
"Stephen" wrote: Hi Folks, i have a macro which automatically protects all the sheets in a workbook. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="my password here" Next ws but i need to allow users the aboloty to change the format options of any cells even if they are locked. any help is greatly appreciated. thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet protection and cell fomat changes
2003
"EbonLinctus" wrote: What version of Excel are you using? Your code may help me solve my issue. "Stephen" wrote: Hi Folks, i have a macro which automatically protects all the sheets in a workbook. Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="my password here" Next ws but i need to allow users the aboloty to change the format options of any cells even if they are locked. any help is greatly appreciated. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell locking and sheet protection | Excel Discussion (Misc queries) | |||
| Fomat Cell | Excel Discussion (Misc queries) | |||
| how do I fomat cell for latitude | Excel Discussion (Misc queries) | |||
| Cell but not sheet protection | Excel Discussion (Misc queries) | |||
| Cell Colors and Sheet Protection | Excel Discussion (Misc queries) | |||
Hybrid Mode
