Stop Cafe Changing in Excel
A client has recently added a cafe to their budget and frustratingly Excel wants to put the accent above the e. Here’s how to stop that.
(more…)Sheet Exists Function for Excel VBA
Often when you are working with Excel VBA you need to confirm if a sheet exists based on the tab name. This Function can be used to do that. It works with the active file (workbook).
(more…)Excel and MYOB
These two Apps don’t always play nicely together. MYOB has a bad habit of turning off calculation in its Excel files. Here’s how to fix it quickly.
(more…)Outlook macro to stop sending an email without an attachment [VIDEO]
I don’t do many Outlook macros, but this one is really useful and I have used it for a long time. It looks at your outgoing email and checks to see if you have the word attach in it and then checks to see if you have an attachment. It warns you if you don’t.
(more…)