View Single Post
 
Old 09-11-2015, 08:31 AM
jc491's Avatar
jc491 jc491 is offline Windows 7 64bit Office 2013
VBA Novice
 
Join Date: Sep 2015
Location: UK
Posts: 55
jc491 is on a distinguished road
Default

Greg,

thank you so much for your help.
I deleted the Arial Font Macro and pasted the function into a module.
Although it does not show up on the macro list - I called the function name - and it worked!


Thank you to Graham for the Batch Auto Addin.
This will be a life saver - especially when you have really deeply nested folders and a million files to process.
Doing it manually has given me RSI - its a nightmare to process that many documents manually.
Thank you to the kind help of the PRO VBA programmers! Kudos!

Now I have to try and convert all my macros to functions

Thanks again

J
Reply With Quote