Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to end macro on inital active worksheet containing macro button that was clicked
I developed a formating macro that can be run by clicking a button on anyone of 20 worksheets. Currently the macro always ends on the 20th worksheet. How can I get the macro to return me to the worksheet I was on when the macro was activated?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to end macro on inital active worksheet containing macro button that was clicked
Set shFirst = Activesheet 'do your bit shFirts.Activate -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Silverhawk1" wrote in message ... I developed a formating macro that can be run by clicking a button on anyone of 20 worksheets. Currently the macro always ends on the 20th worksheet. How can I get the macro to return me to the worksheet I was on when the macro was activated? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to end macro on inital active worksheet containing macro button that was clicked
Hi Silverhawk1
For most of the things you don't have to select the sheets in the loop. Then your sheet stay active. But if you must select then you can use this Sub test() Dim Asheet As Worksheet Set Asheet = ActiveSheet ' your code Asheet.Select End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Silverhawk1" wrote in message ... I developed a formating macro that can be run by clicking a button on anyone of 20 worksheets. Currently the macro always ends on the 20th worksheet. How can I get the macro to return me to the worksheet I was on when the macro was activated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro button gets bigger when clicked | Excel Discussion (Misc queries) | |||
Button macro to move/delete active row | Excel Discussion (Misc queries) | |||
Change Macro button color after clicked | Excel Discussion (Misc queries) | |||
Need to identify active worksheet in macro | Excel Worksheet Functions | |||
Macro to increase cell value by 1 each time button clicked | Excel Programming |