Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Open workbook with same worksheet

How can I always open a workbook at the same worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Open workbook with same worksheet

Create a macro like

Sub Auto_Open()
ThisWorkbook.Worksheets("Sheet2").Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"pkeegs" wrote in message
...
How can I always open a workbook at the same worksheet?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Workbook to Specific Worksheet? Steven Hilgendorf Excel Discussion (Misc queries) 14 June 27th 07 12:22 AM
Copying A Worksheet From Each Open Workbook to an new Workbook carl Excel Worksheet Functions 1 January 3rd 06 05:37 PM
open workbook on same worksheet Anthony Excel Discussion (Misc queries) 2 October 5th 05 06:42 PM
Is there away to open a worksheet outside of the workbook? Jeff Excel Discussion (Misc queries) 2 March 11th 05 03:25 PM
Copying Worksheet to Another Open Workbook [email protected] Excel Programming 2 September 15th 04 01:30 AM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"