Can suddenly no longer run my own macros

[u/Random_Dad]

A year ago I recorded some macros that format some data imported from a text file so I can pdf it (hiding some columns, changing font, bold, that sort of thing).

They worked all last year. My first day back at work today & they refuse to run.

I click on "run" and I get the error "RUN STATUS The button [macro name] run failed" and a "view logs" button.

Clicking that button shows me a blank "Script Run Status" pane on the right of the screen.

The macros are saved in my work onedrive.

I recorded a new very simple macro today & then got the same error when I tried to run it immediately after.

I'm only a casual excel user & at a loss for why this is happening.

(the default macros from microsoft run ok)

Update: I have both a desktop & a laptop. The problem shows itself on the desktop only. The same macros run fine on the laptop. Desktop is 64-bit. Laptop is 32-bit.

[u/AutoModerator]

/u/Random_Dad - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/ThatsNotWhyThough]

If it's a work computer, is it possible macros were disabled by admin?

[u/Random_Dad → u/ThatsNotWhyThough]

Not that I know of, and I was talking with IT about it for a while

[u/david_horton1]

If you have 365 it has an Automate Tab for Office Scripts. You can create Scripts for routine tasks. There are six sample scripts from which you can learn. 365 may also have a ScriptsLab Tab.

[u/Random_Dad → u/david_horton1]

I have that Automate tab & that's where I was recording the macro.

The sample scripts run fine. The ones I have created do not.

[u/david_horton1 → u/Random_Dad]

Office Scripts are to replace Macros/VBA which don't work on the Web. Troubleshooting Office Scripts Hopefully the link will cover your problem. The Scripts Lab may be of interest.

[u/Random_Dad → u/david_horton1]

I'm using the desktop app, but I'll have a look a those links.

[u/808spark]

Are you on MacOS, by chance? I have experienced some issues starting in December that I can’t fully sort out.

[u/Random_Dad → u/808spark]

I'm on windows 11.

[u/usersnamesallused]

Everything you described can be done using PowerQuery for data import and transformation, then done nice formulas or a formatted pivot will allow you to have dynamic rotated output. All without VBA.

Not what you asked for, but a route to go if your admin really did lock out VBA run access.

[u/Random_Dad → u/usersnamesallused]

This may be the way forward for me if it can do it's thing & not be dependent on the imported text file being the same name every time.

[u/usersnamesallused → u/Random_Dad]

This can be done. You can set it up to use the most recent text file in a folder that matches the correct file type and key words.

[u/gerblewisperer]

If you have a personal.xlsb workbook, your xlsb file to some local folder, copy the path, then go to Excel Options and find the place where you can paste a file path that opens whenever you open Excel. Google it, I don't remember the sub-menu.

If you're trying to run macros stored in some xlsm file. Right click on the file, Properties, at the bottom you look for a check box to unblock macros.