|Subject:||Macro - protection with filter|
|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!
With Worksheets("FCW Tracking Recs")
.Protect Password:="calibtn", userinterfaceonly:=True
.EnableAutoFilter = True
Thank you -- Suzanne.