Suppress the Disable Macros / Enable Macros Dialog

  • Thread starter Thread starter Shoji Karai
  • Start date Start date
S

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.
 
Shoji Karai said:
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.
Click to expand...

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.
 
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
 
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
 
TroyW said:
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
Click to expand...

Hi Troy,

That's perfect - exactly what I was after.

Thank you so much!

Alan.
 
Back
Top