Hi Mark,
I am so happy it is working a treat in excel, exactly how I imagined it but could not explain it succinctly.
I was careful not to mess about to much with it in case I broke it.
I can put all my macros in any module, and then just update my macro list sheet and hey presto,
That saves me a lot of time and hassle.
I have a lot of mini macros and well they are a real headache because it would take me ages to find and edit them, and i would also change the name and then it would get lost - so that was a no no, I have to keep organised as I'm a hopeless newbie coder
The original task is complete.
Now since it worked so well in excel, may I trouble you just a little -
Would this work in Word? I could make a list of macros names in an excel sheet and just reference it.
I would just use the excel sheet to organise my macros.
The word macros would stay in Word.
If its not too much of a headache - would you be good enough to have a look at the word form.
I transferred the excel modules and classes and form to word. ( Hope i didnt make a dogs dinner of it)
I didnt want to start a new thread as I'm not sure if its possible, and if not I am happy with my Excel Version
thank you again and grateful for your advice and help
dj
Reply With Quote