08 6210 8500
Excel Warning Box By Wyn Hopkins In a nutshell: Save yourself a lot of wasted time and turn off DropBox badges.... If you ever experience a VBA Password box appearing after you close Excel and then the dreaded "Microsoft Excel has stopped working" message then there may be a simple solution...... After much debugging [...]
58 Crazy Excel Stories (that are probably happening in your company right now)!Crazy things happen when you mix untrained users with Excel.It’s not really rocket science. Crazy things would happen with any complex system if you don’t train people properly.But many companies simply assume that everyone knows Excel, so they don’t need much (if any) [...]
The Great 48 Excel Toolbar We love Excel & Word and they can do some pretty amazing stuff. But sometimes there are a lot of unnecessary steps and clicks which are quite annoying, especially when you’re using Excel all day long! So we developed these toolbars for ourselves and now we’re sharing them [...]
A little macro never hurt anyone So here's a little macro that can automatically create and update a contents page with hyperlinks in any of your Excel files. Create a new sheet (call it Contents for example) Right Click on the sheet tab name and select View Code Copy and Paste the [...]
Apologies for the Dad joke above (not really), but in this article, I’ll show you how you can easily get data labels on all your data series, even if you have LOTS. All it takes is a little VBA code. In the data set below, I’ve made up some stats about how [...]
Hiding and unhiding sheets I hide a number of sheets in the workbooks I create because they are used for workings. Is there an easy way to make them all visible at once? By Neale Blackwood The following macro will unhide all the sheets in the active workbook.: Sub UnHideAllSheets() 'this macro unhides all [...]
Save All Open Files I work with a model that has many files and links between the files. When I make structural changes that affect links I have to go through and save all the open files to make sure the changes are kept. Is there a way to save all the open files [...]
Link sheet name to cell value Is it possible to link the sheet name to a cell's contents? I want the sheet name to be whatever I enter into cell A1. By Neale Blackwood There is no built-in Excel function or feature to do this. You have to use an event macro. The macro below [...]
List of sheets with hyperlinks I regularly create a list of sheets in a contents sheet in my files. I then create hyperlinks to the sheets. Can this process be automated? By Neale Blackwood The macro below will create a list of all sheets in the current workbook. This list will start at the [...]
Full Path name in Footer How can I put the full path name of my file in the footer without typing it? By Neale Blackwood Excel XP and 2003 allow you to easily insert the full path in your footer using the Page Setup, but unfortunately earlier versions don't. In Excel 97 and 2000 [...]
Hiding and unhiding quickly I frequently hide and unhide the same sets of rows in my sheet, so that the detail doesn't print on my reports. Is there an easier way to do this? By Neale Blackwood The feature that would make hiding and unhiding specific rows easier is called Group. Select the rows [...]
Protect and unprotect sheets macro I frequently protect sheets without using a password to ensure users don't accidentally change something they shouldn't. Is there an easy way to unprotect all the sheets in a workbook and then protect them again? By Neale Blackwood There is no built-in method to protect or unprotect all the [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
