Saving just as macro-enabled Workbook possible?

[TheIntern]

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

 

[pedie]

I think you can force the users to enable the macro for the workbook to some extent by hiding Worksheets in veryhidden before close and disable SAVE AS for the workbook so that they dont save as to other formats.

Just a thought!

[/FONT]
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
    MsgBox "Save As is disabled", vbInformation
    Cancel = True
End If
End Sub

 

[TheIntern]

Thanks for your quick reply!
If there is no way to permit to save in another way than macro-enabled, I will use this approach.
If they want to have the original file again, they have to copy it in advance.