How can I tell if VBA is running in an .XLSM?

[Plasmech]

I have a .xlsm with embedded VBA code. I believe the VBA code has stopped running.

How can I tell, definitively, if VBA is running?

Also, I would like to add something to the VBA code to show an error on the spreadsheet if VBA fails to run. What would the easiest way to go about this be? I'm thinking of a line of code that hides a "VBA FAULT" cell.

Thanks for any help, as always.

Please let me know if I'm not using the proper terminology.

 

[Joe4]

Thanks again for all the help you have provided.

You are welcome.

I would like to have VBA actively suppress a "VBA Fault" message (or cell contents). Is this possible?

That sounds like an entirely different question that probably should be asked in a new/different thread.

 

[Plasmech]

You are welcome.


That sounds like an entirely different question that probably should be asked in a new/different thread.

I agree. Good suggestion. I will do that.

Thanks.