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. |
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. |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com