Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Disable the Macro Pop up | Excel Programming | |||
Disable Macro | Excel Programming | |||
Disable Macro at open by an external macro | Excel Programming |