restrict module operation

[Curt]

Not sure how to post this. I have a module tht is used on one wks. When I
copy data to another sheet this module activates on it as well. How can I
restrict the operation to my one data sheet. Is this per public or private
code somehow? It is a module within my modules in VBA project window
Thanks

 

[Jay Freedman]

Not sure how to post this. I have a module tht is used on one wks.
When I copy data to another sheet this module activates on it as
well. How can I restrict the operation to my one data sheet. Is this
per public or private code somehow? It is a module within my modules
in VBA project window Thanks

It sounds like you're doing this in Excel, which handles modules much
differently than Word does. Try asking in the Excel group,
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.