Hi: I have a macro that runs fine unless i protect my worksheet then i get a 1004 error .. so i tried:
============================
Private Sub Workbook_Open()
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.Protect UserInterFaceOnly:=True
Next
End Sub
===============================
no luck .... the macro still fails ....
any ideas ?
Thanks
============================
Private Sub Workbook_Open()
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.Protect UserInterFaceOnly:=True
Next
End Sub
===============================
no luck .... the macro still fails ....
any ideas ?
Thanks