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!

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!

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!

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!

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!