Macros stopped working?

[MarcosM]

Hi Guys, I recently got some great advice on here regarding a function I wanted to get working.

I added some code to the vb module, referenced it back in the worksheet and all worked great for a couple of days.

Im now opening the *xlsm and none of the calculations are working, just #NAME ?

Any ideas?

 

[MarcosM]

Also, macro settings are Enable all Macros and Trust acccess to VBA object model is selected..

 

[Fluff]

A few things to check.
1) Does the Function still exist in that workbook?
2) Are macros enabled?
3) Has the function been renamed?

 

[jasonb75]

Did you save the code in the correct workbook?

Code saved in "Book1" will only work in "Book2" when "Book1" is open.

You might be better off using this method for user functions. https://bettersolutions.com/excel/macros/personal-xlsb.htm

 

[MarcosM]

Ive just checked and the code was missing from the module...!! Re added and it works fine now!

I never thought to check as I cant think of a reason why it would suddenly not be there are using the workbook many times..?

 

[Fluff]

If all code disappeared it could be that the file was saved as an .xlsx at some point.
If it was just the Function that disappeared, then maybe the module was deleted by mistake.

 

[MarcosM]

If all code disappeared it could be that the file was saved as an .xlsx at some point.
If it was just the Function that disappeared, then maybe the module was deleted by mistake.

Thanks for the info!

 

[Fluff]

You're welcome & thanks for the feedback