Action may not bring happiness, but there is no happiness without action.
Benjamin Disraeli (1804-1881)
Monthly Archives: June 2022
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.
Knowledge of what is possible is the beginning of happiness.
George Santayanna (1863-1952)
Sheet Exists Function for Excel VBA
A function macro to help another macro
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).
We should not let our fears hold us back from pursuing our hopes.
John F Kennedy (1917-1963)
Excel and MYOB
Calculation issues
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.
If you add only a little to a little and do this often, soon that little will become great.
Ancient Greek poet Hesiod
Works And Days
Outlook macro to stop sending an email without an attachment [VIDEO]
Automatic attachment check via VBA
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.
A change in perspective is worth 80 IQ points.
Alan Kay
Talk at Creative Think seminar