With your permission, if I may suggest, add additional information to your question. Information about your Excel version, operating system, storage medium, so you could get a solution to your problem much faster and more accurately.
If it is Excel for web
Work with VBA macros in Excel for the web
Thank you for your understanding and patience
I know I don't know anything (Socrates)