var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Getting rid of Prompts in a Macro ?
In a macro i've created, I delete some sheets and create a new file, populate it with info, then save it.
But I get prompts whenever it gets to the lines which either delete the worksheets or save the file.
Is there anyway to suppress these prompts ?
Add this right before your troublesome alerts.
Application.DisplayAlerts = False
Then be sure to add this before the macro ends.
Application.DisplayAlerts = True