Import module code to sheets module ?

[Rmag]

Hello quick question how to import vba code directly to sheets module..??

Please Login or Register  to view this content.

this is code for exporting module an importing module ( as standard module )
does any one know how to import standard module to specific Sheets module ???


Best Regards

[Kyle123]

Why do you want to do this? There's probably a better way

[Kyle123]

Duplicate post

[Rmag]

i want to do this because i need to use..

Please Login or Register  to view this content.

and this must be in specific sheet module

[cytop]

this must be in specific sheet module

Why?

You can use the Workbook_SheetChange event in the ThisWorkbook class to determine which sheet was changed and run code depending on that.

Totally ignoring the security implications of allowing code to change the project.