Force "Enable Macros"

[esib]

Hello

I have seen workbooks that will not allow you to open them unless you select "enable macros." Just wondering if anyone knows how this would be accompished.

Thanks

 

[macropod]

Hi esib,

I don't believe you can.

However, a workbook could be set up so that all except one worksheet is hidden and the rows & columns on the one visible worksheet are hidden. An Auto_open macro could then unhide them.

Similarly, the macro could be used to populate the workbook with data - unless the Auto_open macro was run, the data wouldn't appear on the worksheet.

Cheers

 

[SkipVought]

Hi,

You can't "force" enable macros.

But you can save and open the workbook in a state that is unusable unless macros are enabled.

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]

 

[esib]

Thank you for the replies. I admit, I didn't see how what I was asking would be possible. I have done your suggestions, and that works fine, but just thought I would ask. I think my mind is playing tricks on me and I never actually saw a workbook do what I was proposing.

 

[esib]

Here is what I am talking about:

I am launching excel from withing an SAP application and when I select to disable macros I get the message:

"This workbook contains a type of macro (Microsoft Excel 4.0 or Visual basic) That cannot be disbled..."

So you either enable macros or the workbook will not open. Could it be that there is some ABAP code through the SAP to Excel communication, controlling this?