Forum Discussion
Macro enabled spreadsheet problems - Date picker (calendar)
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
Hi Haytham,
question on this again. If the spreadsheets we use are saved on a network, how will this macro work? Will I have to save it to the laptop of each team member so when they open these network files it will run or is there a way of saving the macro on the network location itself?
Hi Joy,
Please note that the solution in the links is based on the Get & Transform (aka Power Query) not in a macro.
The Power Query is the best solution when you want to combine/append multiple tables have the same fields in one table.
If the spreadsheets are saved in a network drive, you need to move them into one folder to be able to use the solution that explained in the second link.
In fact, I provided you with these links because it's hard to explain this process in a reply here.
Regards,
Haytham