I have a file that currently has one button that goes to a "MainMacro" module that will call other modules and also run slightly different code for 17 different locations that will eventually send emails to these locations. I'm trying to create buttons for each location for the purpose of running this report for just a specific location when needed. What I'm envisioning is that I will click the location button and it will call one module then call the "MainMacro" module then goto the Line or Label to run that specific location.
Location Button would run this
Which would then go to Line 'BU 46572 in this next code to what ever label needs to go there. I'd like to stay away from Line Numbers in case there are modifications to the code at a later date.
This Main_Macro will goes through 15 other locations with some slightly different code. Basically I just need it to just run the code for the septic location from the original button click
Bookmarks