I have 10 text boxes (that I use as buttons) that have variables on click will trigger and open charts on one sheet.
vReport = 2.14
What I would like to do is when the sheet is opened, (activate sh01)
for it to open vReport = 2.14 also, rather than have to physically press the button for the conditional report to appear.
Can this be done?