How to start macros?

Jens 0 Reputation points
2024-03-22T14:05:49.2+00:00
Hello,

I got a new Dell laptop and it runs Windows 11 with Office 365.

I use an Excel that also has macros in it. On other computers, Excel with the macros runs perfectly.

I entered the folder as trustworthy in the trust center and also selected the fourth point in the macro settings.

"Enable VBA macros (not recommended...)"

When I then want to start the macros using the buttons, nothing happens. I can then no longer do anything in Excel. Running it manually via the “Developer Tools” tab doesn’t work either. Excel is also “frozen” here. I then exit via the task manager and close the app there.

Do you have any idea what I can do?

Thanks in advance

Jens
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,437 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
    2024-03-25T06:17:30.0466667+00:00

    Hi,

    I suggest you try to open VB editor in Excel using Alt + F11 keyboard shortcut.

    I also suggest you try to repair Office application:

    https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

    It is also recommended that you check whether the firewall and anti-virus software are enabled, you can disable these and try agian.

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments