It's not.

If macros can't run, the warning sheets is active.

If macros do run, the Warning sheet is deleted.

BTW, to Activate a specific sheet in 2007, add the following line tat the end of Sub DeleteWarningSheet
Sheets("SpecificSheet").Acivate