Jun 06 2022 08:16 AM
Hi, after the latest Office update (16.0.15225.20204), my company has problems opening excel files with Macros. I have tried in every way to enable them but I can not get over them.
I have enabled macros, set the trusted path and disabled all types of file protection, but it keeps crashing the macro. The file is located on a network location.
Can anyone help me?
Thank you
Jun 09 2022 02:41 AM
Recorded macros mostly contain "instructions" like... select, selection, active cell,
but this makes the workbook slow and error-prone.
Have you tried using a module instead of a macro?
...so that such problems could perhaps be eliminated.
...is just a thought :).
I know I don't know anything (Socrates)
Jun 16 2022 01:11 AM