autofilter and protection (Excel 2000)

Topic

New Reply

Is there a way to make the autofilters work when a worksheet is protected?
Thanks,
–cat

Reply | Quote

Replies

hmmm … not till Excel 2002?

Reply | Quote

I don’t have Excel 2000, but Googling I found that you can enable AutoFilter in a protected sheet using a macro containing the following code:

With Sheet1 ‘Or whatever name
.Protect UserInterfaceOnly:=True
.EnableAutoFilter = True
End With

You must run this code each time the workbook is opened (for example in an AutoOpen or Workbook_Open macro), for the setting is not stored with the workbook.

Reply | Quote

This also works with XL97. If MANUALLY protect it first before saving it, you can add a password that is NOT listed in the macro code so when the workbook open macro runs the sheets still have the password.

Steve

Reply | Quote

Thanks! That works great.
–cat

Reply | Quote