Thread: Protecting worksheet cause vba code to fail
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick H[_3_] Nick H[_3_] is offline
external usenet poster
  
Posts: 48
Default Protecting worksheet cause vba code to fail
Hi Ken,

This is probably because the 'AllowFormattingCells' property is set to
false.

If you are manually protecting the sheet you can put a tick next to
'Format Cells' in the Protect Sheet dialog.

HTH, Nick H
Reply With QuoteReply With Quote