•Unlocking Spreadsheet for making changes
1. | Select Tools > Protection > Unprotect Sheets from menu |
2. | Password: accubuild (all lower case) |
•Locking Spreadsheet for making changes
1. | Select Tools > Protection > Protect Sheet from menu |
2. | Password: accubuild (all lower case) |
3. | Enter password again when prompted |
•Changing VB Script for SQL Data Selections
1. | Enable the Control Toolbar by selecting View > Toolbars > Control Toolbar |
2. | Click Design Mode Button on Control Toolbar to enter design mode. |
3. | Right-Click on Update Lookup Lists Button and select View Code |
4. | Password: ACCUBUILD1987 (all upper case) |
5. | Make necessary changes and then select File > Save to save changes. |
6. | Select File > Close and return to Microsoft Excel. |
7. | Click Exit Design Mode Button from Control Toolbar to exit design mode. |
8. | Select File > Save to save the spreadsheet and then close Excel. |
|