Copy code of Sheet module into the rest of sheet's modules

cgcamal

Active Member
Joined
May 2, 2007
Messages
472
Hi everybody,

Please some help over here.


I have 50 sheets, I have an event code in Sheet2 module, and I want to execute the same code event in all 49 sheets (excep sheet1).


I need to copy in sheet3 to sheet50 the same code I have in Sheet2 module?
If the answer is yes, how can I copy Sheet2 module code into the Sheet3 to Sheet50 without doing one by one?

Or is there other way to execute the same code of Sheet2 module in Sheet3 to Sheet50 without copy it into every sheet?

Many thanks in advance for any help.

Regards
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
AlphaFrog,

Many thanks for the link! of course will be extremely useful
.

After seeing a little bit the content, it seems will be a great help to learn more of Excel VBA events for me.

Many thanks for help in this solution and for your time.:)

Best regards
 
Upvote 0

Forum statistics

Threads
1,225,156
Messages
6,183,226
Members
453,152
Latest member
ChrisMd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top