Results 1 to 3 of 3

Open Workbook to last active sheet

Threaded View

zplugger Open Workbook to last active... 03-22-2015, 10:30 AM
berlan Re: Open Workbook to last... 03-22-2015, 10:36 AM
zplugger Re: Open Workbook to last... 03-22-2015, 10:39 AM
  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Open Workbook to last active sheet

    Have a workbook with a lot of sheets,can I open it to last active sheet if saved to different name? Workbook is called Master,so if it's call something different it opens to last active sheet.Now
    the workbook opens to proposal as default.Need to open to last active sheet?

    If ThisWorkbook.Name = "Master" Then
    Sheets("Proposal").Select
    else
    If ThisWorkbook.Name <> "Master" Then
    ??????????????????
    End If
    Last edited by zplugger; 03-22-2015 at 10:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open Another Workbook from Active Workbook but stay on Active Workbook.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2014, 06:33 AM
  2. [SOLVED] save active sheet in new workbook, naming it as cell value of active sheet
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2014, 06:16 AM
  3. Replies: 1
    Last Post: 01-04-2014, 06:37 PM
  4. [SOLVED] VBA to Open File (filename contains current date) & copy Sheet to active workbook
    By jlstidham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 10:50 PM
  5. [SOLVED] COPY from an open workbook with particular sheet and columns to active workbook
    By purin0c0 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2012, 03:57 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