Hello Excellers, today let's look at a really quick way to hide an Excel worksheet if a specific word appears in another worksheet. I find this really useful when I am working on an Excel solution,...
Category: Macros
Unhide Multiple Worksheets At Once With A Small Piece Of VBA Code – Macro Mondays
You probably already know that you can only unhide one Excel worksheet at a time. If you did not then just test it for yourself. Try to unhide more than one of your hidden worksheets in an Excel...
How To Write A Macro Which Saves A Daily Copy Of your Excel File- Macro Mondays.
Welcome back to another #macromondays post. Today I want to share with you how to write a small piece of VBA code which creates a macro to save a copy of your Excel file on daily basis. Each of...
MS Excel Tutorial- How To Show Formulas In Excel With A User Defined Function – Formula Friday
It sometimes it is really useful to show your Excel formulas on your worksheets. This gives an insight into the logic of the worksheet. It also is a great way to check your formulas to ensure...
How To Write An Excel Macro To Log Changes To An Excel Workbook – Macro Mondays
Do you like a bit of Big Brother?. Or do you just want to know if someone has changed something on your Excel worksheet? Either way, here is how to track and document changes to an Excel workbook...
Write An Excel Macro To Display A Message When Data Has Been Updated- Macro Monday
Hello Excellers. Welcome back to another #macromonday blog post. I want to show you how to write an Excel Macro which will display a message when data has been updated. So how will this be...