VBA to password protect but keep the ability to format of cells

[Robert_G]

I have this code below & it works to password protect the sheet, but the cells are still locked to format. Any suggestions what I am missing?



Sheets("Cell_Data").Protect Password:="password", AllowFormattingCells:=True

 

[Peter_SSs]

The code allows me to format cells (eg Bold , background or font colour, borders etc)
Could you have some other code somewhere (eg event code) that is applying protection without allowing formatting?

 

[Robert_G]

Found it. I had another module that I forgot about. Once applied, all is well.

 

[Peter_SSs]

Found it. I had another module that I forgot about. Once applied, all is well.

Cheers. Glad you got it sorted.