FishingIsMoreFun
Board Regular
- Joined
- Sep 10, 2011
- Messages
- 135
Hi all
I have an income budget workbook and the information it hold will be important.
Certain sheets hold VBA and spreadsheet formula.
I have Protected the important sheets however Excel still allows for a sheet to be deleted (with warning).
At present I am not sure if protecting the whole workbook will cause the VBA to bug out and I will have to add "Protect"/"UnProtect" Workbook everywhere, but I guess I would like to leave the usability of deleting a sheet.
Is there anyway for VBA to detect when a user has clicked "delete" and apply a warming before the standard Excel warning appears.
I delete so many sheets If get tired I can be careless and have often clicked "Delete Sheet" after the windows warning, just out of habit.
Cheers
I have an income budget workbook and the information it hold will be important.
Certain sheets hold VBA and spreadsheet formula.
I have Protected the important sheets however Excel still allows for a sheet to be deleted (with warning).
At present I am not sure if protecting the whole workbook will cause the VBA to bug out and I will have to add "Protect"/"UnProtect" Workbook everywhere, but I guess I would like to leave the usability of deleting a sheet.
Is there anyway for VBA to detect when a user has clicked "delete" and apply a warming before the standard Excel warning appears.
I delete so many sheets If get tired I can be careless and have often clicked "Delete Sheet" after the windows warning, just out of habit.
Cheers