Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a workbook with a sheet called "Master" and I am using th following line of code to add a new sheet called "Test" (if "Test" doe not already exist) : Sheets.Add.Name = "Test" Is it possible to add this new sheet WITHOUT Excel automatically makin that the active sheet. TIA Seamu -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 back from modeless userform to sheet | Excel Programming | |||
Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming |