View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jc jc is offline
external usenet poster
 
Posts: 164
Default 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