I use Macro custom function to get the sheet names in a list. The other faster method given to my staff is using Excel VBA to populate a list box of sheet names to preview selected sheet.
I'm keen to know the short-cut method which can be done manually. Please share the trick with all.
1 comment:
I use Macro custom function to get the sheet names in a list. The other faster method given to my staff is using Excel VBA to populate a list box of sheet names to preview selected sheet.
I'm keen to know the short-cut method which can be done manually.
Please share the trick with all.
Post a Comment