Excel 2010 not running Macros

Phate

Phate

Phate

Caporegime
Joined
1 Nov 2003
Posts
35,691
Location
Lisbon, Portugal
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
 
Alt F11 will open the VBA editor so you can check the macro :)

Pure guess, but the description about not being able to use File > Options has happened to me in the past when either a macro is running or has hung, or sometimes if Excel is waiting for something to finish (i.e you're in the middle of filling out a cell).

You could try escaping your way out and see if that fixes anything or if it's machine specific, might be worth checking if error messages are disabled locally?
 
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 :)
 
Are you sure it's not related to the December update issue? Is is an ActiveX button or a 'regular' button? Can you run the macro directly through the Macros window? Can you step through the macro in the VBA editor? (F8 to step through line by line)

Are macros disabled entirely in the security settings?
 
You must log in or register to reply here.
Back
Top Bottom