I’m not opposed to using VBA. I think it’s great fun and it can be very useful. But in a business setting, if VBA need not be used, it needs not to be used.
Recently, for example, someone asked an Excel forum how to write a VBA macro that would list all the sheets in a workbook. This macro is needed, the Excel user said, because he has a lot of sheets in his workbook and he wants a quick way to find a specific sheet.
There’s an easier way to solve this problem.
Just right-click on the little arrows in the bottom-left corner of your workbook. You’ll see a list of up to 15 worksheets in your workbook. If your workbook contains more that 15 sheets, click on More Sheets at the bottom of the list. This brings up a dialog that lists all sheets in your workbook.
To activate any of the sheets in the list of 15, just click on the name. In the dialog, just double-click on the name, or select the name and then choose OK.