Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worbook.Activate Activates sht 1 even though this was'nt active sh
I have a workbook created from a template.
I has one event subroutine Workbook_BeforeClose In my code I activate the workbook Workbook.activate Even though another sheet was previously active this line of code activates the workbook and makes Sheet(1) the active worksheet. This is not the behavior with other workbooks. The previously active sheet stays is activated. Is there some setting causing this? -- JC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worbook.Activate Activates sht 1 even though this was'nt active sh
I have found that setting the window.caption to something new causes this
problem. I started a new thread with this detail included. -- JC "jc" wrote: I have a workbook created from a template. I has one event subroutine Workbook_BeforeClose In my code I activate the workbook Workbook.activate Even though another sheet was previously active this line of code activates the workbook and makes Sheet(1) the active worksheet. This is not the behavior with other workbooks. The previously active sheet stays is activated. Is there some setting causing this? -- JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when I activate a cell i change color of active row & header from | Excel Worksheet Functions | |||
VBA Code Activates a workbook only sometimes | Excel Programming | |||
Rectangle that activates a macro | Excel Programming | |||
VB activates unwanted function | Excel Programming | |||
Solver activates other worksheets - why? | Excel Programming |