My application have more than 50 tabs so user wants a list box by which he can search any tab easily. Is it posssible to activate any sheet on selection of sheet's name in list box?
Hi, what you need to do is to load a data island which is all the sheet names you have along with the sheet id of each one, then add a trigger to the sheet name field, the trigger should be an activate sheet one using =only(sheetid) as the function and add your list box containing that field.
Hi, what you need to do is to load a data island which is all the sheet names you have along with the sheet id of each one, then add a trigger to the sheet name field, the trigger should be an activate sheet one using =only(sheetid) as the function and add your list box containing that field.
