ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   enabling macros (https://www.excelbanter.com/excel-programming/320089-enabling-macros.html)

[email protected]

enabling macros
 
Hi,

Is it possible to make a spreadsheet with macros that opens and does
not require the user to enable the macros when the sheet is open.
thanks


Fredrik Wahlgren

enabling macros
 

wrote in message
oups.com...
Hi,

Is it possible to make a spreadsheet with macros that opens and does
not require the user to enable the macros when the sheet is open.
thanks

It seems as if you want to bypass security?

/ fredrik



brian walker

enabling macros
 
NO.

But you can "self Sign" the macro (at least you can with newer versions of
office like XP). So that the first time you or a co-worker opens the file
containing a macro they can click a box that says something like...

"Allways allow macros written by billy bob"

And presto. No more popup box.

search the grooup for "self sign" for instrusctions.



wrote in message
oups.com...
Hi,

Is it possible to make a spreadsheet with macros that opens and does
not require the user to enable the macros when the sheet is open.
thanks





All times are GMT +1. The time now is 11:46 PM.

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