***** Visual basic worked perfectly before on my old iMac, so I have no idea what has happened here to throw it out.
If Visual Basic for Applications is installed, make sure the path to the installation folder does not contain any characters outside of the system code page (such as Cyrillic characters on an English system) and contains fewer than 255 characters. Everything worked flawlessly apart from one thing - whenever I try and use a macro now in MS Office 2011 I get the following message: ***** Can't load Visual Basic for Applications Make sure Visual Basic for Applications is installed on your computer.
I've just moved all my files from my old iMac to my new (well new to me - it's a second-hand 2010 2.4 GHz 13 inch model) MacBook Pro using Migration Assistant.