Named Range override when copying worksheet

  • Thread starter Thread starter JimBob
  • Start date Start date
J

JimBob

I have a worksheet that I use as a "template" - layout, formatted correctly,
etc.. When I start my macro I copy that template to a working worksheet
where I start to populate data, formulas. The template has named ranges in
it. When I copy it I get a message asking me to copy teh named range, or
point to another reference soemwhere on my computer ... isn;t there an option
to override that and just accept the YES option for each named range when
copying a worksheet?
 
Jim,

At the beginning of your macro include the line:

Application.DisplayAlerts=False

This will suppress the dialog box. Excel will then assume you are saying
'Yes'.

It is also good practice to include the line at the end of your macro:

Application.DisplayAlerts=True

Have a look at the help file notes on this.

Regards
Paul
 
Ohh ... yeah ... works great - thanks !

Paul Wilson said:
Jim,

At the beginning of your macro include the line:

Application.DisplayAlerts=False

This will suppress the dialog box. Excel will then assume you are saying
'Yes'.

It is also good practice to include the line at the end of your macro:

Application.DisplayAlerts=True

Have a look at the help file notes on this.

Regards
Paul
Click to expand...
 
Back
Top