Thread: Error 400 on making row visible on a protected sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dmexcel dmexcel is offline
external usenet poster
  
Posts: 20
Default Error 400 on making row visible on a protected sheet
thats what I would do


Sub Macro1()
'


ActiveSheet.Unprotect
'your code
ActiveSheet.Protect

End Sub

Reply With QuoteReply With Quote