TinaP
Well-known Member
- Joined
- Jan 26, 2005
- Messages
- 528
I have created a pivot table which displays the amount for cash drawers over a user-selected period of time. Below the pivot table, there are a few rows with statistics for each drawer. The statistics are deleted and regenerated after each pivot table update (using the worksheet event). Because the user can select periods of time of varying lengths, the pivot table will frequently try to overwrite the statistics before the pivottableupdate macro has a chance to take affect and I get a message saying “Do you want to replace the contents of the destination cells in [Cash Drawers.xlsm]PIVOT?”
Is there any way to eliminate the message since the macro will deal with it anyway?
Is there any way to eliminate the message since the macro will deal with it anyway?