Excel files with VBA code not running code. Ribbon commands greyed out.

dano1352

New Member
Joined
Jan 11, 2019
Messages
11
I have existing Excel files that have codes in them. Now all of a sudden the VBA programs are not running and when the file is opened I get no alerts and some of the ribbon commands are greyed out. II believe it has something to do with trusted files or version conflicts. How do I at least get Excel to ask me to trust the file upon opening?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
Are yoiu in design mode? Look for the icon with the triangle, pencil and ruler. If it is highlighted, click it and see if that clears you problem. If not, check if the file is protected and remove the protection.
 

dano1352

New Member
Joined
Jan 11, 2019
Messages
11
Thanks but I just checked. It's not either one of those. I now believe it's a trust issue and these files are opening in protection mode. I've checked all the trust center options and everything looks fine.
 

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
Are these shared files? If not, see if the shared option is selected in Excel Options. Also check for grouped settings.
 

dano1352

New Member
Joined
Jan 11, 2019
Messages
11

ADVERTISEMENT

Not shared files.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,327
Messages
5,624,029
Members
416,006
Latest member
PCaffrey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top