I CANNOT RUN THE MACROS ON EXCEL

Anonymous
2025-03-24T09:26:35+00:00

Hello, I have a problem with using an excel spreadsheet with macros. I did not create this file and I received it from my professor. It was a .xls file and I converted it to an .xlsm file. I enabled all macros, activex etc. from trust center and also unblocked the file from the properties section. I also defined a folder as a trusted location and put the excel file inside it, still I cannot enable the macros. When I try to click on a button it says `Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled.

When I click the Developer tab and click Macros to run them one by one, it says RUN TIME ERROR 9` SUBSCRIPT OUT OF RANGE.

I contacted my professor but they did not created this file they took it from somewhere else. When I dont convert to .xlsm the problem still occurs.

Id like to add a note that I know absolutely NOTHING about coding, vba etc. and I need someone to help me! Thank you so much for all the recommendations in advance!

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Andreas Killer 144.1K Reputation points Volunteer Moderator
2025-03-24T14:01:41+00:00

The issue with that file is that the code and objects contains unicode chars, example:

Sub Baþla()
Sheets("Baþla").Select
UserForm4.Show
End Sub

But if I look at the sheets I can see a sheet "Başla" instead.

The problem with the other macros are the same, the names of the macros contains unicode names.

There is no issue in general with unicode chars, but it depends on the system settings if such files works on your machine. Therefore professional programmers do not use such chars in there codes.

Anyway, it's a small file, and there are just a few places where this names are used, so it's simple to correct this issue. Download this file:

https://www.dropbox.com/scl/fi/7iqtzabis4fqpqri60wah/MMPI_v2.0.2-2-Yasemin.xlsm?rlkey=phpkbmh9wrppdoge4sgfv9k9k&dl=1

Unblock after download, the macros / button works.

Andreas.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Andreas Killer 144.1K Reputation points Volunteer Moderator
2025-03-24T12:08:08+00:00

Upload the original .XLS file here, I'll take a look:

Microsoft Answers Community Public Request - Dropbox

Andreas.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-24T14:28:52+00:00

    Oh my God, thank you so much! It was written by a Turkish psychologist that is why he used Turkish alphabet but I never would've thought this was the reason behind my issue. Thank you again for your help, really appreciate it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-03-24T12:36:57+00:00

    Uploaded it!

    Was this answer helpful?

    0 comments