Excel Security issue

IT Depart 151 Reputation points
2022-10-17T01:28:16.017+00:00

Hi,

One of the user create VBA code in his developer excel tab.

There is no VBA written code for this but he used the Excel Developer Tab > Design Mode for the design on this excel sheet. He have the attached error.

Before enabling the security
250942-image.png

After enabling the security
250897-image.png

What should be done when having this error

250870-image.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,522 questions
Accepted answer
  1. Olaf Helper 40,916 Reputation points
    2022-10-17T07:28:39.52+00:00

    What should be done when having this error

    That's not an error, only a security warning. Is the Excel file saved as XLSM = "with Macro"? Then it has macros.
    Save it as normal XSLX file instead.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. IT Depart 151 Reputation points
    2022-11-07T05:50:31.55+00:00

    Ok, thanks for the input.

    0 comments
  2. Oskar Shon 866 Reputation points MVP
    2022-11-08T18:19:34.483+00:00

    Until now you would add options in XL application to run files with code: Options/trust center/Macro

    258370-xl-oblokowane-makra-2016.png

    If your file you run saved on intranet, you should add serwer as save using Internet icon from Control Panel.

    ![258399-xl-zablokowane-lokalizacje2-vba-makra.jpg]3

    0 comments