View Full Version : Solved: Protect and Specify to Allow Autofilter
belly0fdesir
01-30-2006, 02:01 PM
Forgive me, for I am in the very early learning stages of VBA...
Is there a way in Excel 2003,to have a macro protect your sheets, but specify to allow Autofilter?
Jacob Hilderbrand
01-30-2006, 02:15 PM
Try this.
Sheets("Sheet1").Protect DrawingObjects:=True, Contents:=True, _
Scenarios:=True, AllowFiltering:=True
belly0fdesir
01-30-2006, 02:30 PM
Worked perfectly. Thank you very much!
Jacob Hilderbrand
01-30-2006, 05:47 PM
You're Welcome :beerchug:
Take Care
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.