| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to Apply various Security Levels in Workbooks
I have a workbook with three worksheets. i would like to protect the
worksheets from editting. But it's complicated. upon opening there should be an option to type in one of three passwords. 1st PW will open the workbook and only show Sheet 1 - with no restrictions 2nd PW will open the workbook and only show Sheet 2 - with no restrictions 3rd PW will open the workbook and only show Sheet 3 - with no restrictions No PW will open the workbook and show all Sheets - with restrictions; users can on view the info and use AutoFilter. How can I do this with VBA code? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Levels of Security in Database Tool. ASP Report Maker | Excel Worksheet Functions | |||
| Security Levels and Macros | Excel Discussion (Misc queries) | |||
| Macro - security levels | Excel Discussion (Misc queries) | |||
| Security Levels in 2003 | Excel Programming | |||
| Set Security levels via macro | Excel Programming | |||
Threaded Mode
