northernstar
08-20-2007, 10:43 PM
hi everyone
just a quick little problem
i would like to add some custom buttons to the toolbar and i would like these to run code in every spreadsheet that i open, i can do it but i have to write the code in a spreadsheet then add the buttons, but everytime i run the code that file opens, i have wrote some code wich then closes that file
but just think it would be better if i could avoid this
i know in word i can have the macros in the Normal Project and this runs for every word file that gets open
also if i want to add the same buttons to several pcs on a network is there a quicker way of doing it without having to sit at each machine and manually do it?
many thanks
just a quick little problem
i would like to add some custom buttons to the toolbar and i would like these to run code in every spreadsheet that i open, i can do it but i have to write the code in a spreadsheet then add the buttons, but everytime i run the code that file opens, i have wrote some code wich then closes that file
but just think it would be better if i could avoid this
i know in word i can have the macros in the Normal Project and this runs for every word file that gets open
also if i want to add the same buttons to several pcs on a network is there a quicker way of doing it without having to sit at each machine and manually do it?
many thanks