Press the Alt + F11 (or Option + F11 for Mac) keys to open VBA. Alternatively, you can head to the Developer tab and select Visual Basic . Select Insert at the top and click Module .

Excel Online doesn’t support VBA. Where the procedure goes The first thing to get out of the way is this: You can’t store this procedure in just any workbook.

After that, paste your macro code into this new module and save it using the dedicated option in the File menu. Also, you need to delete the old module by right-clicking it and using the Remove ...

How to use VBA procedures to generate a list of sheet names in an Excel workbook Your email has been sent Image: Aajan Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage ...