Suppress the Disable Macros / Enable Macros Dialog

[Shoji Karai]

Is there a way to suppress the dialog box that pops up when Excel starts
up asking whether the macros are to be disabled or enabled? I naturally
want the macros to be enabled as well. I just want to take out the
possibility of the user disabling the macros.

Thanks in advance.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Alan]

Is there a way to suppress the dialog box that pops up when Excel starts
up asking whether the macros are to be disabled or enabled? I naturally
want the macros to be enabled as well. I just want to take out the
possibility of the user disabling the macros.

Hi Shoji,

Not sure if it solves for you either, but I asked a similar question
recently and got some ideas back.

Thread is here:


If that doesn't work for you (and I would like to achieve almost exactly
what you do), then perhaps other suggestions might follow your post.

HTH,

Alan.

 

[pfsardella]

http://groups.google.com/groups?hl=...&oe=UTF-8&safe=off&th=e407f6fcc5c8f8df&rnum=5
http://groups.google.com/groups?hl=...&oe=UTF-8&safe=off&th=d22ada919fa7c0e8&rnum=1

Or search Google using "Enable macros", "Force macros", etc.

HTH
Paul

 

[Robin Hammond]

It's up to the user how they want to handle macros. Allowing your code to
override security settings would defeat the point of the security.

There are all sorts of answers in the group about hiding the sheets in your
project and only unhiding them through code, so that the average user can't
get at the underlying book unless they allow macros.

I'd say the best solution is to add a digital signature to your project and
hope that any users on Medium security will be prepared to trust code that
comes with that signature.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

 

[TroyW]

Alan,

Here is some code that will create an Excel4Macro sheet in the workbook. You
don't need to put any macro code on the sheet. As you noted, the presence of
the Macro sheet in the workbook will force the user to reply "Yes" to enable
the macros -OR- not open the workbook. The xlVeryHidden will hide the Macro
sheet.

Troy

Sub AddMacro4Sheet()
ActiveWorkbook.Sheets.Add Type:=xlExcel4MacroSheet
ActiveSheet.Visible = xlVeryHidden
End Sub

 

[Alan]

Here is some code that will create an Excel4Macro sheet in the
workbook. You don't need to put any macro code on the sheet. As you
noted, the presence of the Macro sheet in the workbook will force
the user to reply "Yes" to enable the macros -OR- not open the
workbook. The xlVeryHidden will hide the Macro sheet.

Troy

Sub AddMacro4Sheet()
ActiveWorkbook.Sheets.Add Type:=xlExcel4MacroSheet
ActiveSheet.Visible = xlVeryHidden
End Sub

Hi Troy,

That's perfect - exactly what I was after.

Thank you so much!

Alan.