Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my Excel 2020 series. Today I want to show you how to not only hide your Excel formula from users but lock those cells. ...
Posts by Barbara
Macro Mondays – How To Remove All Hyperlinks From An Excel Workbook
Hello, Excellers. Welcome back t another #MacroMonday Excel blog post in my 2020 macro Series. I recently had this question submitted via email from a subscriber. How to remove all hyperlinks. ...
Evil Halloween Excel Trick-A Spreadsheet That Scrolls Backwards
Hello, Excellers. Want a Halloween trick Let's have a bit of fun and be a bit evil?. It is Halloween after all. How about a worksheet prank?. A spreadsheet that scrolls backwards with...
Macro Mondays – What are the Three Windows In The Visual Basic Editor For?
Hello, Excellers. Are you new to Excel Visual Basic?. Just need a refresher?. Well, it is back to basics of the good old macro today. Let's take a look at what the three different Visual Basic...
Macro Mondays – 3 Reasons To Use Comments In Your Excel VBA Code
Hello, Excellers it is time for another blog post on #MacroMonday series again. Today I will go through my top 3 reasons to use comments in your Excel VBA Code. This is sometimes also...
Hello Excellers and welcome back to another #Excel tip in my #FormulaFriday 2020 series. Need to get a reminder in Excel?. Today, let's look at using the NETWORKDAYS function to get a reminder in...