I was reading a post from Hope that was asking about password protecting
individual worksheets in a spreadsheet to allow sales reps to only access
their own information. Frank suggested a macro via a toolbar that would ask
for a password and then the specific sheet. How would I do this or is there
another way? This would save me a lot of time from having to move the sheets
to another spreadsheet and send them out individually.

There are numerous examples in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

Realize, however, that worksheet passwords are extremely easy to bypass.
Anyone with the ability to find these newsgroups will be able to read
your "protected" sheets:

http://www.mcgimpsey.com/excel/removepwords.html


In article ,
"Brad" wrote:

I was reading a post from Hope that was asking about password protecting
individual worksheets in a spreadsheet to allow sales reps to only access
their own information. Frank suggested a macro via a toolbar that would ask
for a password and then the specific sheet. How would I do this or is there
another way? This would save me a lot of time from having to move the sheets
to another spreadsheet and send them out individually.