Forum Discussion
Solved
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...
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
We have the same issue, and all the reading I have done leads to 'No'! - see this short support article https://support.office.com/en-us/article/work-with-macros-in-excel-online-98784ad0-898c-43aa-a1da-4f0fb5014343 There are loads of similar requests for this in the Excel UserVoice.
Thanks Tanya.