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.