Protecting the Workbook and Formulas, and Backups
Protecting sheets and formulas from changes, and backing the file up regularly.
Course contents
- 1Protecting sheets and the workbook
- 2Locking formula cells
- 3Protecting the VBA code
- 4Automatic backups
- 5Restoring data
What you gain from the course
You can protect your system against tampering and data loss.
Other courses in the same track
Stage 5: Security and operation
Users, Permissions and Passwords
A login screen, users with different permissions, and a record of who entered and changed what.
Testing the System and Fixing Errors with AI
Testing with sample data, tracing errors, and using AI to help fix them.
Closing the Financial Year and Carrying Forward Opening Balances
Closing the year’s accounts and creating the new year’s file with its opening balances.