I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***

You can't. Enabling macros is a security feature to prevent viruses. It would
not be too useful if a virus could just enable macros.

What you can do it look at digital signatures or setting up a system to make
the spreadsheet indicate that Macros are not enabled. Basically have a sheet
that gets hidden by a macro. If macros are not disabled then the sheet does
not get hidden and the end user is notified of the need to enable macros...
--
HTH...

Jim Thomlinson


"Mariam Mata" wrote:


I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***

Macros must be enabled before the open event can take place.

Otherwise there would be no need for macro security settings.

Maybe re-think your project needs?


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 08:14:26 -0700, Mariam Mata wrote:


I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***

One idea...

You could run a VBScript before opening the Excel file to set the macro
security to medium or even low. Here is a script that will change the macro
security level to low for Excel XP. The path may change a bit for different
versions of Excel.


Option Explicit
Dim objShell, RegLocate
Set objShell = WScript.CreateObject("WScript.Shell")
On Error Resume Next
RegLocate =
"HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\ Excel\Security\Level"
objShell.RegWrite RegLocate,"1","REG_DWORD"
WScript.Quit




"Mariam Mata" wrote in message
...

I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***

You can't force macros to be enabled. That would invalidate the entire
purpose of disabling them. One option is to make your workbook unusable if
macros are disabled. See http://www.cpearson.com/excel/EnableMacros.aspx .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Mariam Mata" wrote in message
...

I need to enable macros on open event...

Sugggestions,
Thnaks a lot !

*** Sent via Developersdex http://www.developersdex.com ***