Thanks Roger, I'll have a go

Tim

"Roger Govier" wrote:

> 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
>