Open a Workbook to a Specific Sheet

Sometimes you need to open your workbook be started on a specific worksheet. With this macro, if a user is working with...
0

Unprotect a Worksheet on Workbook Open

Sometimes you need to unprotect the worksheets in a workbook before continuing your work. If you find that you’re constantly unprotecting worksheets,...
0

Protect a Worksheet Before Workbook Close

Sometimes you need to send your workbook out into the world with specific worksheets protected. If you find that you’re constantly protecting...
0

Auto Save a Workbook Before Closing

This macro is an excellent way to protect users from inadvertently closing their file before saving. When implemented, this macro ensures that...
2

Saving a Workbook When a Specific Cell Is Changed

Sometimes, you may want to save a workbook when a specific cell is changed or range of cells is changed. This macro...
0

Creating a New Workbook Using Macro

Perhaps you may need to create a new workbook in an automated way. For example, you may want to copy data from...
0

REPT function

Description REPT function repeats a piece of text a specified number of times. Use REPT to fill a cell with a number of...
0

How To Create Sparklines Use Excel Functions

Sparklines is new in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of...
3