southamptonexamfactory

rename a macro

click on the macros icon in Developer: 2. select the macro you want to rename and click Edit. This will bring up the code for that macro. 3. change the name to the new one. Make sure there are no spaces and make sure you leave the () at the end of the name. I’mContinue reading “rename a macro”

record a macro

Sometimes you want to do a repetitive task in Word and you think, ‘It’s a computer – it can see what I want to do, why can’t it just carry on and finish the job?’ In this situation make a macro to do the job. All you have to do is carry out the taskContinue reading “record a macro”

open another document from the Quick Access Toolbar

I have one particular document which I use very often when I am writing resources. Because I frequently need to open it from the document I am currently working on I have an icon for it on the Quick Access toolbar: The document has all my organic displayed formulas on it. When I need aContinue reading “open another document from the Quick Access Toolbar”

remove double spaces

My colleague Ada Nurel is always very frustrated by numpties who put double spaces into their documents, and especially ones who spread out their chemical equations with lots of spaces. She notes that when she does a ‘replace all’ and replaces a double space with a single it will still leave double spaces since threeContinue reading “remove double spaces”

sort out font for Cl and Al

In Arial the font for the 9th letter and the 12th letter of the alphabet are the same, which means that the symbol for chlorine is the same as for carbon monoidide. OCR exam papers solve this problem by writing the 12th letter of the alphabet in Book Antiqua Italic when it is in theContinue reading “sort out font for Cl and Al”

landscape format

My Russian colleague Edna Ural produces a lot of resources in landscape format since they are intended for the student to look at on their screen rather than to be printed out. This macro formats a landscape document in House style:

impressive resources using bookmarks and hyperlinks

I use bookmarks and hyperlinks a lot when making resources. I have therefore added them to my Quick Access Toolbar so that they are available with one click: Bookmarks and hyperlinks in a Word document are still active when the document is saved as a pdf. A Word document hundreds of pages long takes upContinue reading “impressive resources using bookmarks and hyperlinks”

add an equilibrium sign

In AutoCorrect I have added eqmz in the left-hand box and ⇌ in the right-hand box. This means that every time I need an equilibrium symbol I just type eqmz. See here for how to add to the AutoCorrect table. See here for how to find the Unicode symbol for the equilibrium arrow on theContinue reading “add an equilibrium sign”

add a macro to the Quick Access Toolbar

I use my formatting formulae macro a lot so I have a smiley face icon for it on the Quick Access Toolbar: To assign a macro to the Quick Access Toolbar do the following: Right-click on the Toolbar Select Customise the Ribbon Select Quick Access Toolbar 4. In Choose commands from pick Macros 5. SelectContinue reading “add a macro to the Quick Access Toolbar”

insert a formatted table

I use a lot of tables when I am making resources here at Southampton and I always like them in this format: column headings bold and justified left-hand column aligned left all other columns justified I used to spend a lot of time formatting each table that I drew but now I have an iconContinue reading “insert a formatted table”