Disable MACRO
 

Hi All

I have an excel file, in which we populate an PIVOT Table.
The data population works fine, the only issue is, right before the data
gets populated it displays window 2 times, the text on this window is

"do you want to replace the contents of the destination cells in results"

Questions, how do I disable this window so that user does not have to click
OK button on these window

Note: I have set the MACRO Security as LOW

Thanks
PP

Disable MACRO
 

This has nothing to do with security. Security only has to do with whether
macros will run or not. Your problem is that excel is alerting you that it is
about to overwrite something. Generally a very useful thing but somethimes
annoying. To turn this off use code similar to this (error handling is always
a good idea when you change application level settings)

Sub MyStuff()
On Error Goto ErrorHandler
application.dislayalerts = false
'Do you stuff

ErrorHandler:
application.dislayalerts = true
end sub
--
HTH...

Jim Thomlinson


"PP" wrote:

Hi All

I have an excel file, in which we populate an PIVOT Table.
The data population works fine, the only issue is, right before the data
gets populated it displays window 2 times, the text on this window is

"do you want to replace the contents of the destination cells in results"

Questions, how do I disable this window so that user does not have to click
OK button on these window

Note: I have set the MACRO Security as LOW

Thanks
PP