+ Reply to Thread
Results 1 to 4 of 4

open excel file in a specific sheet

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    borazjan
    MS-Off Ver
    Excel 2007
    Posts
    50

    open excel file in a specific sheet

    i have an excel file with 3 sheets,
    every time that i open this file, i want it to show sheet2.
    i want do it without macro.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,414

    Re: open excel file in a specific sheet

    If you don't want to use a macro, then you should return the cursor to sheet2 before you save the file when you use it, so that it will open with the cursor in the same place.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    08-05-2013
    Location
    borazjan
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: open excel file in a specific sheet

    Quote Originally Posted by Pete_UK View Post
    If you don't want to use a macro, then you should return the cursor to sheet2 before you save the file when you use it, so that it will open with the cursor in the same place.

    Hope this helps.

    Pete
    thanks, but not helpful, because i don't want to save it in sheet2 every time.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,414

    Re: open excel file in a specific sheet

    Well then, you can't do it without using macros.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open specific excel file and log file information
    By chidmas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2013, 12:37 PM
  2. [SOLVED] VBA Script to open a specific File adn activate a specific sheet within that sheet.
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2013, 01:31 PM
  3. Open an Excel file at a specific time
    By awbf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 01:18 PM
  4. Open file at specific sheet?
    By teeb in forum Excel General
    Replies: 1
    Last Post: 12-26-2006, 02:35 PM
  5. [SOLVED] I need a shortcut to make a excel file open to a specific sheet
    By EAHRENS in forum Excel General
    Replies: 9
    Last Post: 12-06-2005, 03:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1