Re: Using auto filter when worksheet is protected

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Note:
In 2002-2003 this is a option when you protect your ***.
No need for VBA code then


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:43874646.2080504@xxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Tim
>
> You need to add the following code to a module in the workbook
>
> Sub auto_open()
> With Worksheets("sheet1")
> Active***.Protect Password:="roger", _
> DrawingObjects:=True, _
> Contents:=True, Scenarios:=True, _
> AllowFiltering:=True
> End With
> End Sub
>
> Change Password to whatever is used by you.
>
> You can copy the code I posted and paste it into your Visual Basic Editor
> (VBE) in a Standard Module located in your Workbook. Shortcut
> keys would be ..
>
> Alt + F11 (open VBE)
> Ctrl + R (open Project Explorer)
> Select file on left
> If no modules exist:
> Insert | Module
> Paste code in Module
> If modules exist:
> Double click desired module
> Paste code in Module
>
> Regards
>
> Roger Govier
>
>
> Tim wrote:
>> Hello
>>
>> I'm just adding the finishing touches to a spreadsheet and a large area of one of the worksheets has been protected. However the
>> spread*** is designed with the functionality of autofilter in mind. When I protect the *** it no longer gives the ability to
>> auto filter. Is this just the way it is or does anyone have any suggestions
>>
>> Thanks in advance
>>
>> Regards
>>
>> Tim


.

Quantcast