Any way to use VBA to comment out / uncomment a standard module?

**vwhite** · 09-04-2020, 06:41 PM

Hi All

I have this module in several workbooks

Module Name: Has_Formula

Please Login or Register  to view this content.

I'm hoping there's a way to use the Workbook Open() event to un-comment all 4 lines
And Workbook_BeforeClose() event to comment them all back out again

Is that even possible?

**mikerickson** · 09-04-2020, 07:30 PM

Rather than commenting out a UDF, its much easier just to not use it.

And, yes you could use code in the Open event to remove all the REMs from commented out code. The problem is that you couldn't use that module until the changes were Saved.
I should mention, that if you are working in a company environment, your Permissions might be set so that you can't edit vb code on the fly.

**Greg M** · 09-04-2020, 08:22 PM

Hi again,

Take a look at the attached workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

P. S. The above approach uses late binding, with the variables "codHas_Formula" and "vbp" being declared as type Object - you can use early binding instead if you create a reference to "Microsoft Visual Basic for Applications Extensibility 5.3"