Set Worksheets to 2

Hi, i was looking for some help with a macro I have written. What I was looking to find out is if it is possible to have 2 worksheets that are set as WS1.

Currently I have the following:

Please Login or Register  to view this content.

but I need the macro to run on 2 sheets i.e.

Please Login or Register  to view this content.

but this gives me an error, any ideas on how i can get this to work?

Thanks in advance.

probably not the best solution

copy/paste your macro, renaming it so you'll have the original macro1 and macro2, which do the same thing.

macro 1 will have

Please Login or Register  to view this content.

macro 2 will have

Please Login or Register  to view this content.

now create a main macro and call the other macros

Please Login or Register  to view this content.

thanks for the replies, i will try these and let u no how i get on.

royUK, thanks for your response. I have a macro that will toggle between the number of jobs an individual has undertaken and the time this has taken him.

Unfortunately I have had issues with another part of the workbook, as the vlookups I have on my main sheet look through 250 different sheets within the same file (as they also toggle between time and %) so i have had leave the formulas in their but when opening the file on some colleagues their computer freezes so I have had to rethink the vlookups.

So what I have done now is copied the main sheet so i now have 2. Where the vlookups were, the first main sheet shows the time, the second the % but the problem now is that the macro I have that would grab the number of jobs an individual has undertaken or the time this has taken him only gets changed on the first main sheet as this is what WS1 has been set to hence the reason why i needed this to work on 2 sheets at the same time.

Sorry if i have gone on abit, but hopefully that makes a bit more sense as to why I need to define 2 worksheets. Also if any1 can give any other suggestions compared to what I have done then feel free to let me know. Would really appreciate it.

Thanks for all your help once again.

Please Login or Register  to view this content.