We show you how to allow macros in Excel for specific or all spreadsheets and how you can lock and password protect Excel spreadsheets.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

What is Macro? Macro is a handy tool for frequent Excel users that helps to save time and automatically configure some commands. Macro works with VBA (Visual Basic for Application) program codes, but ...

There are several ways you can enable macros on Excel. There was a time when macros were very common in Excel, but macro viruses — malicious macros that could inflict serious harm — forced ...

Often we need to carry out manipulations in Excel documents and apply them to multiple rows, columns and sheets. To do this manually takes too much time and allows for errors to creep in, so Excel ...

description: Describes how to use a macro to apply cell shading format to every other row in a selected range in Excel. Microsoft Excel automatically formats new data that you type at the end of a ...

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...