Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative to hardcoded password ?
I have a password-protected worksheet in which users enter input into
unlocked cells. After clicking a button, VBA updates protected cells. To do this, the following statement appears in the Workbook_open proc: ThisWorkbook.Worksheets("User").Protect "mypw", True, True, True, True The worksheet is already saved with the sheet protected. I use this statement for the final "True" argument, to protect the UserInterfaceOnly but permit VBA to update the worksheet. With Excel 2002, I need to hardcode the password in the VBA. (Excel 97, 2000 did not require the password in VBA.) I would like to give the worksheet password to an administrative user to change certain locked cells before the workbook is distributed to the users. But if the administrative user inadvertantly changes the worksheet password, the VBA no longer can update the worksheet. Any alternatives to allowing VBA to update the worksheet without hardcoding the password? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use Find without hardcoded value but a value from a cell | Excel Worksheet Functions | |||
I need to change hardcoded background color | Excel Worksheet Functions | |||
Change hardcoded filename | Excel Programming | |||
VBA Code To find Hardcoded Values in Formula | Excel Programming | |||
DSUM with Criteria containing non-hardcoded values? | Excel Worksheet Functions |