Hi, thanks for looking.
I have a numerous Workbooks created from the same template with several macros, in modules and on the worksheets. I have used these files, multiple times a day since January with no problems, now all of a sudden the macro buttons no longer work unless I open/close and reopen the workbook, i get the error 'Cannot run the macro "Filename!Macro name'. The macro may not be available in this workbook or all macros may be disabled'. The macro buttons run macros that are only stored in modules.
This has really stumped me, as why would it not work and then work if reopened, although this method doesnt work on all the workbooks, some wont work at all no matter how many times I reopen them, and the workbooks have all been created from the same template and used in exactly the same way.
Whats weirder is that I have started creating a new template for 2022, by modyfying the old template, and this does not produce the error at all, even though the macros stored in it, that are run from the buttons have not changed.
The error started approx a month ago around the same time I started creating the new template so I was wondering if perhaps there has been some kind of update effecting the old workbook but not a newly created one but I am clutching at straws now.
I am using form buttons and not command buttons and I have been in the trust centre and tried running all the different options for macro settings but none have worked.
Any help anyone can offer would be appreciated.
Bookmarks