I have cell K24 on a sheet called MAIN. It changes values based upon a concatenate formula (example below. the words google-drive-id are the actual drive ids of the parent folder.
'''
=CONCATENATE("https://drive.google.com/drive/folders/",if(left(B9,3)="020",concatenate("google-drive-id"),if(left(B9,3)="021",concatenate("google-drive-id")))
'''
I have a button that calls the ViewConfig macro below because I can't seem to figure how to make a script open a web browser tab to show the parent folder. So I just tell the user to click on the hyperlink found in cell K24 on the MAIN tab of the google sheet. Clicking on that link opens the Google Drive folder in a web browser tab. I would prefer the macro look up the hyperlink in cell K24 and open the browser tab of that link automatically if possible. Thanks in advance for your guidance.
'''
function ViewConfig() {
Browser.msgBox("View Configs", "Click on the link in Cell K24 for Access to the Google Drive.", Browser.Buttons.OK);
'''
