Compile error on newly recorded macro

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.

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 laptop and it works just fine.


I'm totally stumped. Please help. I have to teach recording macros next week and I can't.

Here is my u tube address ending vIYfgP03Qx4

I've seen this quite a few times, but cannot remember what the cause was.
Along with what 6String has suggested, do you have any add-ins, or COM add-ins loaded?

Reply to the first response#Hmmm no that wasn't the case. If you look at the video,you will see that I just recorded a few simple steps. Something just isn't right..

I'll check your second and third suggestions.

Originally Posted by 6StringJazzer

I viewed your video and I have a better idea of your problem although I have never seen this before. The code you are showing has absolutely no relation to the actions you took when recording the macro. In addition, it is just wrong. That code looks like it was written by hand by someone who doesn't know how to write VBA.

Somehow the module is being seeded with code that was written earlier, but I do not know how this is possible. The only thing I can think of is to check to see if there is an Excel file configured to use as a template for new files that has some bad code in it. I suggest you check to see if there is anything unexpected in the startup folder.

If you don't know where your startup folder is, you can find it in File, Options, Advanced:

Attachment 690180

In Excel 2016, if I go to File, Options , Advanced, I do not see a category for Startup folder. I did, however, check to see if there were some obscure file names where Book 1 should be in places ie: display options for this workbook etc and they all say Book 1.

Originally Posted by Fluff13

I've seen this quite a few times, but cannot remember what the cause was.
Along with what 6String has suggested, do you have any add-ins, or COM add-ins loaded?

No active application add ins nor COM add ins loaded,.'


yup this question is a doozie.

What is the other version of Excel that you are running on that machine?

Originally Posted by Fluff13

What is the other version of Excel that you are running on that machine?

365

I have had both versions for the same amount of time and was able to perform the exact same macro before that VBA course.

Originally Posted by 6StringJazzer

I viewed your video and I have a better idea of your problem although I have never seen this before. The code you are showing has absolutely no relation to the actions you took when recording the macro. In addition, it is just wrong. That code looks like it was written by hand by someone who doesn't know how to write VBA.

Somehow the module is being seeded with code that was written earlier, but I do not know how this is possible. The only thing I can think of is to check to see if there is an Excel file configured to use as a template for new files that has some bad code in it. I suggest you check to see if there is anything unexpected in the startup folder.

If you don't know where your startup folder is, you can find it in File, Options, Advanced:

Attachment 690180

The picture of the startup string in the jpg is not fully displayed.
Could you please copy and paste in the reply? I’m sure that not everything will be the same but maybe I can see something that might help .

I didn't think you could have both a subscription & stand alone version of Excel installed on the same computer.