Unable to set the NumberFormat property of the Range class

[Pinaceous]

Hey Everybody!

I'm working with a sheet upon I have a private sub to provide a specific numberformat for a specific range:

Range("AZ30:AZ36").NumberFormat = "###,###,##0 ""KG"""

Now the code works well situated in the private sub but when I protect the workbook with a password the code produces this message popup error:

Unable to set the NumberFormat property of the Range class

Can someone help me run this numberformat code with the workbook locked?

Any suggestions would be appreciated!!!

Thanks,
pinaceous

 

[Fluff]

Do you mean the Sheet is locked, rather then the Book?