Excel 2010 not running Macros

Phate · 29 Apr 2015 at 15:28

Hi All,

I've got a machine here at work which will not run any Macros at all. When you click the button to run it absolutely nothing happens at all. Also afterwards you cannot open File > Options (can click it, but nothing happens)

It's really strange. Macros are set to enabled. It's not from the Microsoft Dec 2014 patch issue where they broke Macros....its very peculiar.

If anyone has any ideas....

TIA
Jake

Phate · 29 Apr 2015 at 19:06

Yes, they've been using this spreadsheet for months.

Phate · 29 Apr 2015 at 19:46

What does alt F11 do? I can try it tomorrow back in the office.

We use SCEP AV

Phate · 30 Apr 2015 at 08:10

To give you an idea of what this Macro does:

Click the button - It then gives you 3 prompts, making sure you have done X Y Z checks before it runs - you confirm these - it then starts pulling data from different worksheets then spits them into a PDF format, rinse and repeat

It's not even giving the 3 prompts, at this point the macro is hardly doing any work whatsoever so I don't think it's hung or running at this point.

Its definitely a machine specific issue, I can run the macro on my PC for example.

Where would I check the error messages being disabled?

Thanks for all your help btw