Vba and macros not running

[matthec2]

Hello,

I have a file with macros that emails a spreadsheet to a list of names.

On Friday, it was working fine. However, when I've gone into it today, the buttons have stopped working.
I can't even run the code when I go into Visual Basic and click Run. Nothing happens.

I have had this problem before in previous files and I was told it might be to do with Updates. My other macro enabled files still work ok, it's just this one.

Any ideas I can do to fix this without rebuilding the whole file?

Thanks!

 

[Psytrese]

Try: File > Options > Add-Ins > Manage: Disabled Items > Go

Check if the book is here, if so Enable.

 

[matthec2]

Thanks for the reply.
That hasn't worked unfortunately - I did think it would be something like that.

 

[Psytrese]

Not sure what else it could be. If other XLSM's are working then your security settings must be fine.

Have you tried opening it up in VB and trying to Compile it?

 

[matthec2]

How would I open it in VB? I've never tried that before - I only ever use VBA behind Excel.

Thanks!

 

[Michael M]

It's not in break mode is it ??
Also, check to make sure you don't have an active cell in the workbook, where you need to press enter or Esc to complete the cell activity

 

[sh1ne]

Where you store the macros?