Protection & Filtering

  • Thread starter Thread starter Liz Smart
  • Start date Start date
L

Liz Smart

I have a management information system which exports data
to excel when reports are run. I want to be able to take
the resulting excel spreadsheet and protect the majority
of its contents to avoid accidental erasure. I then wish
to insert several columns into the sheet which people can
update as the month progesses. These columns are therefore
to remain unprotected. I can do this using the 'locked'
feature of format cells but when my sheet is protected I
am unable to filter the data. I understand why this is
happening but does anyone know a way round this as the
filtering options are an essential part of the spreadsheet.
Thanks
Liz
 
Apologies my email is (e-mail address removed) if
anyone wishes to advise me by email.
Thanks
 
You need a macro that unprotects the data, filters, then re-protects
Using the macro recorder should work OK
 
Back
Top