Macros on Protected Sheets

G

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro on a protected worksheet in a shared workbook. 1
Macros for Protect/Unprotect all sheets in a workbook 2
Run Macros in Shared Workbook. Help !!! 2
How to run Macros in Shared workbook 5
My Shared workbook is driving me crazy!!! 1
Macros on Protected Sheets 5
To Norman or Alan Macro About Macros protected Sheets 1
Hi! Urgent pls: Protecting sheets so macros/buttons still work? 5

Top