Thread: Excel VBA error on protected worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Casey[_6_] Casey[_6_] is offline
external usenet poster
  
Posts: 1
Default Excel VBA error on protected worksheet
I'm a VBA beginner, however I have fixed a similar problem with the
following.

Sub Your_Procedure

ActiveWorkbook.Sheets("Your sheet name").Unprotect (YourPassword)

YourCode

ActiveWorkbook.Sheets("Your sheet name").Protect (YourPassword)

End Sub


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote