Hi,
When i open my application i get "Macros may contain virus . It i
always safe to disable macros ...."

Is there any way to disable this function in coding itself.


I also have another problem while saving the xls sheet thru VBA code.
Saving takes a long time to execute why? Is there any way to save th
xls faster. I beleive that it takes long time because if the VB
controls.

Can any body help me out in these two cases.

Thanks
Venkatesh

--
Message posted from http://www.ExcelForum.com

No, you can't disable the warning and retain the level of protection desired
by the user.

--
Regards,
Tom Ogilvy


"kvenku " wrote in message
...
Hi,
When i open my application i get "Macros may contain virus . It is
always safe to disable macros ...."

Is there any way to disable this function in coding itself.


I also have another problem while saving the xls sheet thru VBA code.
Saving takes a long time to execute why? Is there any way to save the
xls faster. I beleive that it takes long time because if the VBA
controls.

Can any body help me out in these two cases.

Thanks
Venkatesh.


---
Message posted from http://www.ExcelForum.com/