ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   macros enable (https://www.excelbanter.com/new-users-excel/11785-macros-enable.html)

myfanwy

macros enable
 
macros are automatically enabled on my pc but when i send
my spreadsheet to work i get it asking me if i wish to
enable or disable macros.

I always want it to be enable. is there a way I can
digitally sign my files at work to stop this message to
automatically enable macros?

Myfanwy

Bill Kuunders

toolsoptionssecuritymacro securityselect "low"

regards
Bill K
"myfanwy" wrote in message
...
macros are automatically enabled on my pc but when i send
my spreadsheet to work i get it asking me if i wish to
enable or disable macros.

I always want it to be enable. is there a way I can
digitally sign my files at work to stop this message to
automatically enable macros?

Myfanwy




Michael

Hi
While Bill has given you the answer, keep in mind that this security setting
will apply to all macros.......even those sent via the Net from unscrupulous
sources and could allow your PC to become infected.

HTH
Michael

"myfanwy" wrote:

macros are automatically enabled on my pc but when i send
my spreadsheet to work i get it asking me if i wish to
enable or disable macros.

I always want it to be enable. is there a way I can
digitally sign my files at work to stop this message to
automatically enable macros?

Myfanwy



All times are GMT +1. The time now is 10:26 PM.

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