Macro enabled spreadsheet problems - Date picker (calendar)

Hi all, I created a macro for a date picker calendar type thing and saved the file as a macro enabled S/s with the .xlsm format. Does this spreadsheet have to be open each time I want to use th...

excel

Macros and VBA

Haytham Amairah
Oct 30, 2018
Hi Joy,

If you save the macro in the VBA project of a specific workbook, then you have to open this workbook to access the macro.

But you can save the macro in the Personal Macro Workbook, in order to make it available to all open workbooks. Please check out this https://trumpexcel.com/personal-macro-workbook/.

With regards to sharing the workbook with other people, please note that the using macro is one of the limitations of the shared workbook, please check out this other https://www.ablebits.com/office-addins-blog/2017/08/02/excel-shared-workbook-share-file-multiple-users/ for more info.

Hope that helps

Haytham Amairah

Silver Contributor

Oct 30, 2018

Hi Joy,

If you save the macro in the VBA project of a specific workbook, then you have to open this workbook to access the macro.

But you can save the macro in the Personal Macro Workbook, in order to make it available to all open workbooks. Please check out this https://trumpexcel.com/personal-macro-workbook/.

With regards to sharing the workbook with other people, please note that the using macro is one of the limitations of the shared workbook, please check out this other https://www.ablebits.com/office-addins-blog/2017/08/02/excel-shared-workbook-share-file-multiple-users/ for more info.

Hope that helps

Joy Amobi

Copper Contributor

Oct 30, 2018

Thanks Haytham!

Forum Discussion

Macro enabled spreadsheet problems - Date picker (calendar)

Resources