Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
Let's say I'm working in Sheet13 with cursor on B3 Using Alt+F8, I call / run a sub from my personal.xls, for example: Sub SwitchOffGridLinesWS() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ActiveWindow.DisplayGridlines = False Next End Sub The sub finishes its job but the activesheet has changed to the rightmost sheet's cell A1 How do I bring the cursor focus back to where I was when I ran the sub: i.e. back to Sheet13 with cursor on B3 ? Thanks for insights. -- Rgds Max xl 97 --- Please respond, in newsgroup xdemechanik <atyahoo<dotcom ---- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup bringing back #N/A | Excel Discussion (Misc queries) | |||
Bringing quotations back up on screen | Excel Discussion (Misc queries) | |||
How do I get focus back on an Excel file? | Charts and Charting in Excel | |||
Change focus from Userform back to Sheet | Excel Programming | |||
Focus back from modeless userform to sheet | Excel Programming |