Enabling macros and delete a sheet

[jamesgw]

Is there a command that can be put in the "thisworkbook...open" sub that will automatically "enable all macros"? I'm trying to save the step of a user having to click on "enable macros"?

Also, I'm trying to delete a sheet with a macro. All goes well, except the box keeps coming up, asking to confirm that I want to delete. Is there any way I can have it default to "yes" and continue.

[Mudface]

I don't think there's a way around the macro warning pop-up, unless you can persuade all the people using the file to lower their security level.

For the second, use

Application.DisplayAlerts = False

before you delete the sheet. Set it back to true afterwards.

HTH.

[waderw]

For the enable macro question try. going to "Tools>Options" then to the "General Tab" and uncheck "Macro Virus protection"
That should prevent the pop-up asking to Enable,etc