Forum Discussion
Solved
VBA code locks out autofilter
Hello People, The below code runs perfectly, however, the password also locks of the ability to use autofilters after the code has run......can someone kindly advise the code that I need to add s...
Change
wsData.Protect ("ML")
to
wsData.EnableAutoFilter = True
wsData.Protect Password:="ML", UserInterfaceOnly:=True
Change
wsData.Protect ("ML")
to
wsData.EnableAutoFilter = True
wsData.Protect Password:="ML", UserInterfaceOnly:=True
- Thank you again Hans.....I really appreciate it. I am still new to VBA coding and learning, and some things I simply cannot work out lol. Thank you again.
