Thread: Disable MACRO
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pp pp is offline
external usenet poster
 
Posts: 10
Default 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