Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Steve,
One way: Dim WS As Worksheet Set WS = ActiveSheet ThisWorkbook.Worksheets.Add WS.Activate NickHK "Steve Haack" wrote in message ... I am unsing the .Copy method to add new worksheets to a workbook, by copying a template sheet that is already in the workbook. I am calling the code from a command button placed on a home "sheet". The code works fine, but when it adds the new sheet, it changes the focus to it. I would like to know if it is possible to copy/add the new sheet and not have it gain the focus? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Short cut for switching between worksheets | Excel Worksheet Functions | |||
Switching between Worksheets | Excel Programming | |||
Switching between Worksheets | Excel Programming | |||
Switching between worksheets | Excel Programming | |||
Switching to different worksheets during a macro | Excel Programming |