Enable Auto Filters in protected sheet
Activesheet.Protect UserInterfaceOnly:=True
Activesheet.enableAutofilter = true
in xl2002 and later, this can be handled more gracefully by making that
choice in the Sheet protect dialog.
--
Regards,
Tom Ogilvy
"Gordon" wrote in message
...
Hi...
Question says it all. Auto Filters won't work when sheet is protected. Any
code to get around this?
Thanks
Gordon...
|