Share via

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

Microsoft 365 and Office | Development | Other
Developer technologies | Visual Basic for Applications
Answer accepted by question author
  1. Olaf Helper 47,586 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 49,311 Reputation points Volunteer Moderator
    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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.