PC Review


Reply
Thread Tools Rate Thread

When Activating workbook always goes to left most sheet

 
 
jc
Guest
Posts: n/a
 
      22nd Oct 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Should I activate workbook before activating sheet when button is selected? RJQMAN Microsoft Excel Programming 4 16th Sep 2011 05:12 AM
Save each sheet of multi-sheet workbook as a single-sheet workbook CTB Microsoft Excel Programming 3 17th May 2011 08:40 AM
Activating a workbook =?Utf-8?B?Qm9sZGll?= Microsoft Excel Programming 5 19th Jul 2006 03:15 AM
activating a workbook VB Script for Excel Microsoft Excel Programming 12 22nd Mar 2006 07:55 AM
Activating a workbook help bmwmcrider Microsoft Excel Programming 1 21st Oct 2003 01:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:46 PM.