Macro Security Question

ianccy

Active Member
Joined
Jul 28, 2002
Messages
332
I have a workbook with macro button to open another workbook (which has macro in it),

Private Sub CommandButton1_Click()

Workbooks.Open Filename:="C:My Documentsxxx.xls"

End Sub

But when the xxx.xls opens, it does not pop up the security box to select the security option, how to enable this? what should i add to the macro?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Wow, you're the first one asking how to SHOW that message ! :biggrin:

Actually, I think the way it behaves is by design (And I appreciate it for one !), so, I don't think there's a way to display the message via VBA.
 

ianccy

Active Member
Joined
Jul 28, 2002
Messages
332
I found a way to solve this, the workbook (xxx.xls) that i want the macro to be disabled, must be opened first, instead of open it by the second which must have the macro enabled.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,885
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top