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
One other thing Haytham. Can you send me some links on how to transfer data on an Excel form into a spreadsheet or on a word document to a spreadsheet.
I have a form that users complete with certain fields having the same name as column headings in my spreadsheet. I want to be able to transfer all that captured data in the Excel form into a spreadsheet preferably at the click of a button. I am guessing a macro will be ideal or is this more of a pivot table table.
Hi Joy,
I think you don't need to a macro to do that as it's can be done by using Power Query.
Please follow this https://www.mrexcel.com/excel-tips/combine-4-sheets/.
If the spreadsheets are in different workbooks, please check out this https://www.youtube.com/watch?v=ldoQws7Zbx8.