Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I've created five macros to automate formatting tasks in five monthly Excel files then saved these to my toolbar for future use.
However I keep getting the following error message when trying to use them in subsequent spreadsheets:
'Cannot run the macro 'PERSONAL.XLSB!NameOfFile'. The macro may not be available in this workbook or all macros may be disabled.'
Any ideas?
Thanks
You need to save these macros in a macro-enabled workbook and have that workbook open.
(Yes it is not intuitive and I don't fully understand it but this is my workaround).
Thought this was going to be about photography.
Yes it is not intuitive and I don’t fully understand it but this is my workaround
VBA Macros only exist in Excel workbooks. Once you close all your workbooks, any Macros have been removed.
Excel has a fix for this, it has a Personal.xls workbook you can store macros in..
https://www.ablebits.com/office-addins-blog/2020/03/04/excel-personal-macro-workbook/
However, that WB will be personal to you, so send your project WB to a colleague and it's got not macros in it.
Personally, I just add all the macros I want to use into each project workbook (very easy to do, you can just export the relevant VBA module and import it into another workbook in a few mouse clicks).