Hi Guys,
Just a simple one for you,
I have my main subroutine in, for example sheet6, and I have a button in sheet1 that when I press I would like the subroutine in sheet6 to execute, how can I do this ?
Thanks in advance
Adrian
Hi Guys,
Just a simple one for you,
I have my main subroutine in, for example sheet6, and I have a button in sheet1 that when I press I would like the subroutine in sheet6 to execute, how can I do this ?
Thanks in advance
Adrian
Re: Execute a Subroutine from a different sheet
Quote from adetucI have my main subroutine in, for example sheet6, and I have a button in sheet1 that when I press I would like the subroutine in sheet6 to execute, how can I do this ?
Do you mean the code is in the Sheet6 worksheet code module, if so then use
Re: Execute a Subroutine from a different sheet
It would indeed make more sense to put that code in a standard module.
...and then reference the code from the various sheet-coded objects (if necessary).
Re: Execute a Subroutine from a different sheet
OK thanks for the suggestions I will try them
Re: Execute a Subroutine from a different sheet
OK that work now , Thanks for all the help
Case Closed
Don’t have an account yet? Register yourself now and be a part of our community!