Ben77
03-11-2013, 07:38 AM
Hello All,
I relly need your help. I have been trying all morning to sort this out myself and I am failing.
I have prepared a series of Guidance Notes, which when I send must be password protected.
However I want the user to be able to Use autofilter, which I have set up. However the, because of the password protection, they can not auto clear the filters, which is causing some silly mistakes to be made.
Essientially I have tried to write/form a piece of VBA code which does the following via a button:
Unprotects Sheet
Clears filters (manually, as different keyboard shortcuts, etc in different versions of excel)
Re-password protects the sheet.
Surely somebody must have written a piece of code to get rounf this. I would be really greatful for any help.
Thanks:banghead:
I relly need your help. I have been trying all morning to sort this out myself and I am failing.
I have prepared a series of Guidance Notes, which when I send must be password protected.
However I want the user to be able to Use autofilter, which I have set up. However the, because of the password protection, they can not auto clear the filters, which is causing some silly mistakes to be made.
Essientially I have tried to write/form a piece of VBA code which does the following via a button:
Unprotects Sheet
Clears filters (manually, as different keyboard shortcuts, etc in different versions of excel)
Re-password protects the sheet.
Surely somebody must have written a piece of code to get rounf this. I would be really greatful for any help.
Thanks:banghead: