Macro - protection with filter

Giganews Newsgroups
Subject: Macro - protection with filter
Posted by:  Suzanne
Date: Fri, 17 Aug 2007

Hello.  I have a protected worksheet with a macro that unprotects, sorts,
reprotects.  I've had to add the below macro in order for the filters to
function when protected.  All works fine THE FIRST TIME i open the file.
When i close the file and reopen it, the filters don't work, the sort macro
will not run - unless i completely shut down Excel and restart.  I don't even
get the 'enable' macros window at opening.

Can anyone help please?  I got the below of this site and am not sure if
this is what's causing the problem or not.  Many many many thanks!

Sub auto_open()
    With Worksheets("FCW Tracking Recs")
        .Protect Password:="calibtn", userinterfaceonly:=True
        .EnableAutoFilter = True
    End With
End Sub

--
Thank you -- Suzanne.

Replies