How to password protect a selection using the autofilter function?

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi,

Could anyone tell me how I can password protect a selection from using
the autofilter option in Excel 2000. The purpose of this is that I have
a file that has some data under a couple of people's names. I want the
person who selects the data under his/her name to be prompted for a
password so only that person can view the data. I know i can seperate
the data and send it individually, but if I can do the above, then that
would save me some time. If anyone know how to do that please email me
at (e-mail address removed). I really appreciate it. I am not sure if I need
to do a VBA or there is an option for me to do that in Excel 2000

Thanks,
Charles

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
If that data is sensitive enough that you don't want others to view it, then you
shouldn't share it in excel.

Any protection you'd use would depend on worksheet protection and that is not
safe for this type of thing. There's code posted here every week (every day???)
that shows how to unprotect a protected sheet.
 
Back
Top