ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can i disable the warning when i open the my VBA application (https://www.excelbanter.com/excel-programming/306394-can-i-disable-warning-when-i-open-my-vba-application.html)

kvenku[_33_]

Can i disable the warning when i open the my VBA application
 
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


Tom Ogilvy

Can i disable the warning when i open the my VBA application
 
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/





All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com