Macros on Protected Sheets

[Paul.]

Hi ,
Now I have tried Alan's Solution to be able to run my Macros in Protected
sheets but as I am not VB literate, I think I have made a Syntax mistake.

Sub Newaction()
Sheet("Critical Path").Unprotect ("My Password")
' Newaction Macro
' Macro recorded 17/11/2004 by Clifford
'

'
Selection.AutoFilter Field:=1, Criteria1:="="
Sheet("Critical Path").Protect ("My Password")
End Sub

I receive a message "Compile error"
"Sub or function not defined"
Can you tell me what's wrong ?

Regards

Paul.

 

[Norman Jones]

Hi Paul,

Try replacing:

Sheet
with
Sheets

 

[Paul.]

Norman,
Thanks a lot, now it works ! I am so happy as today I have to put my doc on
a shared drive.
Bye