writing vba to change vba module

[splreece]

Hi all,

In ThisWorkbook I have a simple line of code that opens a specific worksheet.

I need a way of using a button to comment out that particular line or the whole module (module called mdl_snapshot).

Is it possible as I can't find where or how to do it and I will be handing over the doc to someone less comfortable with vba then me.

 

[Roderick_E]

The request is not clear. So you want the macro to run parts but not other parts? What is the determining factor(s) whether it runs which parts? Otherwise why not just comment it out with an ' apostrophe before that part of the code???

 

[splreece]

The request is not clear. So you want the macro to run parts but not other parts? What is the determining factor(s) whether it runs which parts? Otherwise why not just comment it out with an ' apostrophe before that part of the code???

Thanks for the quick response (its me not detailing the query properly).

I am handing a dashboard onto a colleague who isn't confident with excel. (So ideally I wouldn't want them going into the vba and altering lines as they may alter the wrong bit)..

The dashboard updates monthly, and as part of the course I have a tiny sub in the workbook that OnWorkBookLoad, opens a tab called "Offline" that acts as a landing page while the dashboard is being updated.

This is manually turned on and off by commenting out the sub "mdl_offline".

My query was (as I am new to vba)....is it possible I can create a button so that when the dashboard is due for an update:
- the user clicks the offline button which removes the comment indicator ' from the "mdl_offline" sub.
- the user clicks the online button which adds the comment indicator ' to the "mdl_offline" sub.


Its not a clever sub in anyway and only controls the opening tab, so I am simply turning that sub off and on using comments to either land on landing page or not.


I hope that helps a bit.... I am not experienced with VBA so a lot of my coding is probably based on non-programmer logic which is probably different from the preferred vba logic.

 

[Michael M]

Rather than try to modify the code itself, why use a MsgBox to ask the question
"Is the Dashboard due to be updated"
If Yes, then trigger the update code !!!

 

[splreece]

Ahh I would love to be able to.

We aren't at that level yet as most of the dashboard data comes from sources that varying in recording methods.. so I have a lot of automation but also a lot of manual copy and paste stuff (no way round that as I don't own the data or recording device......yet).


So auto updating is out... for now.

 

[Michael M]

I don't follow..

This is manually turned on and off by commenting out the sub "mdl_offline".

If you can manually comment out part of the sub, you can add a MsgBox to ask the user "do they want to proceed"...that will do the same thing.
Can't offer much more without seeing that particular sub....Can you post it ???

 

[RoryA]

You might also use a cell or defined name that the code can check before running the routine. That would be a lot simpler for an inexperienced user to change.