HI all, i have been using the following code in a sub Worksheet_Activate. However it means that whenever the sheet is activated the code runs each time.
What i really want is for the code to run just once, say perhaps when the code is activated using a command button (i know how to do that).
the problem is that there are 4 sheets i need the code to run on: page1, page2, page3 and page4.
Is there a way to get the code to spool to each sheet and run this piece of code?
Hope ive myself clear, thanks again. here is my code as it stands:
LucePlease Login or Register to view this content.
Bookmarks