The laptop that I have was given to someone who had a VBA course. Something unknown to the user/myself was done to this laptop during the course and now it can't do a simple recorded macro like it used to. It comes up with a "compile error". I've done this macro several times, along with other macros and it just doesn't work.
Please see this YoutubeVideo so you can see for yourself.
I've tried to see if there any autoexec macros, hidden macros listed in personal macros (unhide workbooks), under macros there are non listed. I have another version of Excel on the same computer and macros work just fine.
I'm totally stumped. Please help. I have to teach recording macros next week and I can't.