Hi Tim

You need to add the following code to a module in the workbook

Sub auto_open()
With Worksheets("sheet1")
ActiveSheet.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 spreadsheet is designed
> with the functionality of autofilter in mind. When I protect the sheet 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