|
•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. |
|