Can you help?

I am using a macro to update a pivot tbae but when I run the macro a
dialogue box appears saying:

Do you want to replace the destination cells in report3?

The answer to the question is always Yes but how do I get the macro to answe
yes and not to display the fialogue box to the user?

Many thanks,

Nick.

Nick,

Try setting the DisplayAlerts property to False. E.g.,

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nick" wrote in message
...
Can you help?

I am using a macro to update a pivot tbae but when I run the
macro a
dialogue box appears saying:

Do you want to replace the destination cells in report3?

The answer to the question is always Yes but how do I get the
macro to answe
yes and not to display the fialogue box to the user?

Many thanks,

Nick.

Spot On!!

Thanks for that Chip.

Regards,

Nick.

"Chip Pearson" wrote in message
...
Nick,

Try setting the DisplayAlerts property to False. E.g.,

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nick" wrote in message
...
Can you help?

I am using a macro to update a pivot tbae but when I run the
macro a
dialogue box appears saying:

Do you want to replace the destination cells in report3?

The answer to the question is always Yes but how do I get the
macro to answe
yes and not to display the fialogue box to the user?

Many thanks,

Nick.

An alternative would be to clear the area that might be impacted by the
pivot table, prior to modifying the table. If the data can be overwritten
(i.e. it is no longer needed) it would seem to be appropriate to remove it
in every case.

--
Regards,
Tom Ogilvy

Nick wrote in message
...
Can you help?

I am using a macro to update a pivot tbae but when I run the macro a
dialogue box appears saying:

Do you want to replace the destination cells in report3?

The answer to the question is always Yes but how do I get the macro to
answe
yes and not to display the fialogue box to the user?

Many thanks,

Nick.