If you have a long document and want to copy part of it this is a quick way. There is a message box at the start requiring the page range to copy. These pages are then copied to a new document.
Tag Archives: Macro
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”
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:
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”
draw an electrode potential table
If you are producing resources for the electrochemistry topic you often need to draw this table: It looks like a two-column table but if the left-hand column is actually three columns you can keep the equilibrium signs underneath each other in their own narrow column which has no left or right border. Once you haveContinue reading “draw an electrode potential table”
remove automatic numbering but keep the numbers
Automatic numbering is a good servant but a bad master. It’s possible to turn it off but what happens if you have somebody else’s document with lots of automatic numbering that you want to turn off but keep the numbers generated by it? My Australian colleague Ned Alaru gave me such a document. The codeContinue reading “remove automatic numbering but keep the numbers”
Chemistry Word VBA macros 