Hello all,
i have tried to use this to run a macro on a sheet but the Thing is that i want it to run on another sheet not the selected one is this possible?
![]()
Please Login or Register to view this content.
Hello all,
i have tried to use this to run a macro on a sheet but the Thing is that i want it to run on another sheet not the selected one is this possible?
![]()
Please Login or Register to view this content.
Last edited by george.m; 08-31-2017 at 04:21 AM.
What does your badly spelled calculating macro do?
Yes it is possible.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
can you please Show me how it's done
Last edited by george.m; 08-31-2017 at 07:21 AM.
Herr George,
You can run any macro from any sheet. The event you choose to run your macro from doesn't matter, it could be sheet activation (any sheet activation), selection change, worksheet change.....even workbook open. You run your macro in the exact way you show in your original post.
The bit that matters is the code in the macro that runs. If it's full of commands that start with 'ActiveSheet'.....then you'll need to replace those with the specific sheet you want the command to have an effect on....which is why I ask what your calculation macro does.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks