password for worksheets cont...
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.
|