ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Get rid of sercurity box (https://www.excelbanter.com/new-users-excel/31137-get-rid-sercurity-box.html)

Yuri Weinstein \(HotMail\)

Get rid of sercurity box
 
How can I get rid of security dialog which comes up when I open a XLS file
with macros?

Thx
YuriW



Ron de Bruin

Hi Yuri

If you trust all your workbooks then change security to low
ToolsMacro..Security

You can always open a workbook without activating the macro's by
holding the shift key when you open a workbook in Excel


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Yuri Weinstein (HotMail)" wrote in message m...
How can I get rid of security dialog which comes up when I open a XLS file with macros?

Thx
YuriW




Yuri Weinstein \(HotMail\)

But I actually want to have macros and also don't want the dialog come up.

Can I do this?

"Ron de Bruin" wrote in message
...
Hi Yuri

If you trust all your workbooks then change security to low
ToolsMacro..Security

You can always open a workbook without activating the macro's by
holding the shift key when you open a workbook in Excel


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Yuri Weinstein (HotMail)" wrote in message
m...
How can I get rid of security dialog which comes up when I open a XLS
file with macros?

Thx
YuriW







All times are GMT +1. The time now is 01:43 PM.

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