Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macro automatically when we open a workbook
Is there a way to enable macro automatically? everytime I open a specific
workbook? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macro automatically when we open a workbook
Of course! Open 'ThisWorkbook' and pop your code in there. Someting like
this: Private Sub Workbook_Open() MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com" End Sub Set Macro security level to 'Low'. See more details he http://www.ozgrid.com/VBA/auto-run-macros.htm Remember, the enable macros issue is part of Excel's inbuilt security & cannot be bypassed. Individual installations of Excel can alter the settings so that macros are automatically accepted - this can be done by selecting Tools|Macros|security & setting the option from High or Medium to Low - but....it needs to be done for every potential user.... i.e. not a great solution... HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: Is there a way to enable macro automatically? everytime I open a specific workbook? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macro automatically when we open a workbook
For a specific workbook you would have to digitally sign that workbook.
If for use on your own computer only you can use the SelfCert tool that comes with Office. If for use on other computers you would have to purchase a digital signature. See help on digital certificates or digital ID Gord Dibben MS Excel MVP On Tue, 4 Aug 2009 08:52:01 -0700, sam wrote: Is there a way to enable macro automatically? everytime I open a specific workbook? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable macro message on VBA Workbook Open then macro ends | Excel Programming | |||
How to enable Macro automatically | Excel Worksheet Functions | |||
How can I enable my macro to only open for one particular workbook | Excel Programming | |||
Run a macro automatically on workbook open | Excel Worksheet Functions | |||
Enable macros automatically for a workbook | Excel Discussion (Misc queries) |