Just turn protection off temporarily for the sheet:
Sub YourMacro()
Worksheets("SheetName").Unprotect
' macro code here
Worksheets("SheetName").Protect
End Sub
--
- K Dales


"Daniel R. Young" wrote:

I have macros that hide rows and I want to protect my sheet so individuals
will not be able to change any of the information. When the sheet is
protected the macro will not work. It goes to a debuger.

Is there a way to run my macros even though the sheet is protected?

Thank you,

Daniel