Microsoft Excel spreadsheets can contain scripts known as macros. Macros are small, simple programs within Excel (or other Office programs) that can automate common tasks. There was a time when macros ...

Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook. We hide sheets for many reasons, but mostly, to keep other people out of them ...

Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...

Excel macros save you time and headaches by automating common, repetitive tasks, and you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel, it’s as simple ...

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook. Whether your Microsoft Excel workbook has three sheets or 50, knowing what you have is important.

Though Microsoft has backed off earlier plans to block unsafe macros in Excel documents, that change is still coming. Here's what to do now to stay secure. On July 8, Microsoft pulled back from its ...