Allow filtering to a protected workbook

[matrixpom]

Hi all,

I have a code that allows access to nominated staff only, as a "Guest" only you have no access to changing any cell content, however I want to allow the "Guest" the ability to filter...don't understand why my code still won't allow filtering? See below, as always thanks for any assistance, cheers guys - Marco

Please Login or Register  to view this content.

[mjr veverka]

You should set the code so that "UserInterfaceOnly:=True" is in the "Workbook_Open" procedure of the "ThisWorkbook" module

[matrixpom]

Hi porucha vevrkuy,

This code is in the "Workbook_Open", full code below. This should allow a non user, "Guest" to use filtering on the protected pages, but sadly this doesn't work? See below, thanks again for any advise - Marco

Please Login or Register  to view this content.

[matrixpom]

Update:

I ended up just adding a cmdbutton with:

Please Login or Register  to view this content.

Does the job nicely, thanks anyway guys - Marco