Additional Delete Sheet Warning.

[FishingIsMoreFun]

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

 

[VoG]

I think that your only option is to protect the workbook's structure.

There isn't a Workbook_BeforeSheetDelete or similar event

 

[FishingIsMoreFun]

Ahh ok

I will have to edit the code to allow for the adding of worksheets and protect the book.
It pays to ask on here.

Thanks