Thread: with sheet protection on, macro won't run to add borders around a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lorrie M Lorrie M is offline
external usenet poster
  
Posts: 1
Default with sheet protection on, macro won't run to add borders around a
If protection is off, the macro runs fine. If the sheet and worksheet
becomes protected, the macro produces a runtime error 1004 that I have no
been able to locate how to fix (Visual Basic help was of no help).

The debug points to the following:
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Reply With QuoteReply With Quote