Message box to appear when opeing Excel file

[hafiff]

Hi everyone,
I would like to have a message box to appear when Excel workbook is open. The message is to let the user to "Fill in only highlighted cells" because the remaining cells will be password protected so they don't freak out when trying to fill in un-highlighted cell and it does not work.

I know how to write the code on VBA, but the problem is that I need to convert the file to from .xlsx to .xlsm (macro based).

Is that away that the Excel file is saved as a normal .xlsx file?

Many thanks for your input or any options you can give me.
HA

 

[Smitty]

If you want to have code in your workbook, you'll need to save as .xlsm or .xlsb (I prefer the latter because it compresses very well).

Saving as .xlsx will strip the code out.

 

[JoeMo]

Hi everyone,
I would like to have a message box to appear when Excel workbook is open. The message is to let the user to "Fill in only highlighted cells" because the remaining cells will be password protected so they don't freak out when trying to fill in un-highlighted cell and it does not work.

I know how to write the code on VBA, but the problem is that I need to convert the file to from .xlsx to .xlsm (macro based).

Is that away that the Excel file is saved as a normal .xlsx file?

Many thanks for your input or any options you can give me.
HA

After you have written the code, do a SaveAs and save the file with a .xlsm extension. Files with .xlsx extensions cannot contain macros.

 

[My Aswer Is This]

Using Excel 2013 to set .xlsm as the default save option.
On your menu bar.
Choose File
Choose Options
Choose Save
Choose Save file in Macro Enabled

 

[hafiff]

If you want to have code in your workbook, you'll need to save as .xlsm or .xlsb (I prefer the latter because it compresses very well).

Saving as .xlsx will strip the code out.

Thanks!

 

[hafiff]

How about saving the workbook as .xlsm, but I don't want anyone to be able to view, edit, and run the macro?

Thanks,
ha

 

[Smitty]

You can set the macro as Private or add a declaration to it like:

Sub Macro1(Optional KeepOut As Byte)

Both of which will keep it from appearing in the macro list. You'll probably want to protect the VBA Project as well (Tools-->Options).