Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Giving focus to a particular sheet
Hi
Wonder if someone could offer some assistance? When I open a workbook, I was wondering what code I would use in a macro to give focus to one particular sheet? The sheet is called sheet1 (points for originality!) Thankyou *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Giving focus to a particular sheet
This kind of query can easily be answered by using the macro recorder and
examining the resulting script - a "must do" for anyone beginning to use VBA sheetname = "sheet1" Worksheets(sheetname).activate Patrick Molloy Microsoft Excel MVP "R A" wrote: Hi Wonder if someone could offer some assistance? When I open a workbook, I was wondering what code I would use in a macro to give focus to one particular sheet? The sheet is called sheet1 (points for originality!) Thankyou *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Giving focus to a particular sheet
By number:
Application.Sheets(1).select By name: Application.Sheets("sheet1").select "R A" wrote in message ... Hi Wonder if someone could offer some assistance? When I open a workbook, I was wondering what code I would use in a macro to give focus to one particular sheet? The sheet is called sheet1 (points for originality!) Thankyou *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADDING/DELETING SHEET Without losing focus? | Excel Discussion (Misc queries) | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Printing switches focus off proper sheet | Excel Worksheet Functions | |||
Focus sheet | Excel Programming | |||
Adding a new sheet (no focus) | Excel Programming |