PDA

View Full Version : Call a Macro from another Worksheet



Weezer
09-28-2010, 01:59 PM
Hello everyone,

I have a piece of VBA script that I compiled & it works. I have a function in another worksheet that works perfectly fine too. My problem is either within the function or after it I'm trying to call the Macro that I compiled in another Worksheet to Activate. The reason I'm doing this is because the function runs by a button, so if I put it within the function it will automatically call the Macro and do the function in the other worksheet. I am trying to automate the whole process hence I'm doing this.

I'm not sure if anyone would suggest a sub-routine, but I don't know how to go about that. If anyone could help me out I would really appreciate.

Thanks

Kenneth Hobs
09-28-2010, 02:16 PM
Move the code to a Sub in Module and Call the Sub as needed.