Saving just as macro-enabled Workbook possible?

Hello everyone,

because the file is sent to a lot of different persons, my boss wanted my to protect it and shut down the ribbons, formula bar...so it looks similar on every pc.
I used 'Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"' and a few more.
Now my problem:
Most people save it as macro-free workbook, so if they start it again, all the macros are disabled.
Is there any possibility to allow just saving as a marco enabled workbook?

Thanks in advance,

the Intern

In the VBEditor there is a "ThisWorkBook" object. If you dbl click this object you will be in it's module. The "ThisWorkBook" module has a drop down of event triggers macro stubs. You will want to use code in the "OnOpen", "BeforeClose" and the Save event.

BeforeClose Macro: Use to hide all sheet except one that tell users that Macros must be enabled.

OnOpen Macro: You reverse the "beforeClose" process by showing all sheets and hiding the "macro mustbe enabled" warning sheet.

Now.... if user opens book without macros enabled the OnOpen does not run and so the user only sees the "warning sheet"

"Save" event Macro is where you test to see what file extention the user is saving file with... if it's anything but xls or xlsb you stop the Save and give user a message that they can't do that.

Thanks for your quick reply!
Especially the third paragraph sounds really interisting. How can I:

Originally Posted by nimrod

. if it's anything but xls or xlsb you stop the Save and give user a message that they can't do that.

Thanks again,

the Intern

mmh, not really ;-)
I kind of solved it like that:

Please Login or Register  to view this content.

now I just need the macro to start everytime the file is updated...any ideas how I can do this?

Sorry,
this was the wrong thread, I wanted to post it somewhere else^^
Your right, but the file should have a similar design and disable the users ability to change anything...