ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   When Activating workbook always goes to left most sheet (https://www.excelbanter.com/excel-programming/418905-when-activating-workbook-always-goes-left-most-sheet.html)

jc

When Activating workbook always goes to left most sheet
 
The following line of code:

Workbooks(AccessSht.Range("CurrInfoBkName").Value) .Activate

activates the desired workbook but has started going to the left most
worksheet even though the that was not the sheet previously activated.

When activating other workbooks similarly the sheet previously active stays
active.

Any knowledge of what might be causing this?
--
CroceJC


All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com