Hi,
Just finished writing my macro in a test workbook, the macro will be used on different files not just this one.
I managed to assign the macro to a button on the toolbar, but when im in another file and want to run my macro it opens up the original file that it was created in.
I only want the macro to be associated with excel itself and not with any workbook in particular - is that possible ?
cheers,
ps, yes i know i aint got a clue! - new to this
Just finished writing my macro in a test workbook, the macro will be used on different files not just this one.
I managed to assign the macro to a button on the toolbar, but when im in another file and want to run my macro it opens up the original file that it was created in.
I only want the macro to be associated with excel itself and not with any workbook in particular - is that possible ?
cheers,
ps, yes i know i aint got a clue! - new to this