Running Macros on multiple worksheets

**shivrklfc** · 10-30-2012, 10:06 AM

Hi,

i have a macro that is currently performing actions on one worksheet. I have copied this worksheet and named it something slightly different. I now want to edit this macro so that it runs it also performs the same actions on the copied sheet. There are many other worksheets in my workbook but only want this macro to be performed on sheets "LS04" and "LS05" (the names i have assigned the worksheets)

The code i have running on the the original worksheet is

Please Login or Register  to view this content.

Thanks in advance for your help

**JBeaucaire** · 10-30-2012, 10:24 AM

You could reset the macro to do it's magic on the "activesheet" instead of any specific named sheet. Assuming your macros are getting called in a controlled manner, that should work, no? If you make the macros PRIVATE they won't show in the Macro list so that should suppress accidental manual activation, then you can put buttons on the sheets where you want the macro to work and call it that way.

Please Login or Register  to view this content.

**shivrklfc** · 10-30-2012, 10:38 AM

hi JBeaucaire

Many thanks for your quick response, well the sheet "LS04" is currently in view for the user to input information, "LS05" is a copy of LS04 and is hidden from view, therefore when the user inputs information it is linked with LS05 and copies information across and is not meant to be seen by the user. The issue is that the user can add a set of cells (using the above macro) in LS04 and input extra information and therefore this will not be captured into the copied sheet (LS05). This is why i want the same actions performed on both sheets. Essentially i want any action on LS04 mirrored on LS05.

Thanks