dani9
07-22-2011, 12:52 AM
Hi,
so far you have been very helpfull, so I hope you will help me with this problem also :)
I need to run macros by clicking on a certain worksheet.
So far I have got this:
Sub Worksheet_Activate()
Call ColorBackgorund
Call SetColour
Call RecalculateColor
End Sub
Can it be done, to call the whole Module2, where all the subs are.
And i need it to activate on clicking on worksheet "Performance Report"
thanks in advance!
so far you have been very helpfull, so I hope you will help me with this problem also :)
I need to run macros by clicking on a certain worksheet.
So far I have got this:
Sub Worksheet_Activate()
Call ColorBackgorund
Call SetColour
Call RecalculateColor
End Sub
Can it be done, to call the whole Module2, where all the subs are.
And i need it to activate on clicking on worksheet "Performance Report"
thanks in advance!