I have some code placed in the 'On activate' code of a workbook... however, what i think i need is something like on open.
Looking at the choices for the Worksheet that i can see, i see :-
What i need to do, is the run the code when the workbook is open. just the once. it doesn't need to be called again.. It copies some text into the workbook from another..
Where the Activate code, will only fire when you selected the worksheet, not when its just opened and its already on the right tab. So to get my code to work, i have to click another tab, and then click back ! Duh!