Excel warnings

test3xc31

New Member
Joined
Jun 11, 2019
Messages
24
Hopefully a quick question.

In my sheet I was playing around with some activex controls for a certain function.

When I realised what a headache all the warnings were on startup, especailly as this workbook needs to be distributed I quickly got rid of them all and reverted to standard shape.buttons, deleting all the code linked with the Ax.

The problem is, I'm still getting the startup warnings, sheet running in protected mode on new machines and me having to alter the trust centre, which is 1. not feasible for mutiple machines and 2. seriously not wise! does anyone have any ideas how I can get Excel to realise there are no activex controls or code linked with activex running?

Thankyou1
 
Last edited:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Did you save the workbook as an xlsx file if there's no code in it anymore?
 

test3xc31

New Member
Joined
Jun 11, 2019
Messages
24
Did you save the workbook as an xlsx file if there's no code in it anymore?
Oh theres still loads of code, but rather than just getting the enable macros bar on a new machine. The workbook will not load unless protected mode in the trust center is disabled and even then you get two very nasty looking "Microsoft Office has identifided a potential security conern" Warning every time the workbook is loaded
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
And you're absolutely certain you have removed all the activex controls?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Which version of Excel is it?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,814
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top