What’s happened to my Excel user functions…?

Topic

New Reply

Excel seems to have done some sort of update recently and today, for the first time, my user functions in a spreadsheet (an xlsm file) seem to have stopped working (yielding a #NAME? error) and it looks as if Excel has removed the VBA modules for them.

What’s going on and how do I get them working again? Have tried googling this without any success, so far. Any ideas please?

Many thanks.

Reply | Quote

Replies

My first thought is to see whether the update has modified macro access. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and see whether macros are suitably enabled.

1 user thanked author for this post.

WSVictor Delta

Reply | Quote

Thanks. Yes, macros are suitably enabled.

Fortunately, since this morning, I think I have managed to recover my spreadsheet to normal working order. At first, the 3 modules containing the user functions were listed on the left hand pane but could not be accessed in the main VBA window. After fiddling around, the VBA window started ‘Not Responding’ and then gave me the option to force it to close.

On reopening Excel, a recovered file was offered and this amazingly had the 3 modules in working order. I quickly saved backup copies etc and all seems to have been ok since then, although what happened is still a total mystery!

However, first thing this morning there was definitely a green box message in Excel (on the formula bar) saying something about changing formulas (one I’ve never seen before). To be honest I didn’t read it carefully – wish I had now!

Reply | Quote