Hi mmaginniss,
A couple of suggestions...
1) Being new to Tek-Tips, you're likely not yet aware of the option (see bottom-left-corner of the Tek-Tips screen) - to "Click here to mark this thread for e-mail notification".
This will ensure that whenever someone responds to your posting(s), you'll become aware immediately.
You can also go into your "Personal Profile" (see the top-left-corner of the Tek-Tips screen) - and change your profile to set the e-mail notification to be automatic for all your postings.
2) Regarding your "master sheet" and the need to allow users to filter data while maintaining protection...
Have you considered setting up "macro buttons" for "specific filtering" - the result of which would be the extraction of a copy of the filtered data to a SEPARATE sheet. This way, you could maintain protection on your master sheet, and allow the users access to the data extracted to the SEPARATE sheet.
Alternatively, you could have a VBA routine that would extract ALL your master sheet data to your SEPARATE sheet, and turn on AutoFilter. Being a "copy", you would then not have to be concerned about Protection being disabled.
If you'd like assistance with extracting data (Advanced Filter) using VBA, I have some example files I can email you. These are "introductory" level files and should help in better understanding the Advanced Filter options.
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
