Closed Thread
Results 1 to 3 of 3

opening a worksheet to a standard view

  1. #1
    Registered User
    Join Date
    05-07-2018
    Location
    ontario, canada
    MS-Off Ver
    standard 2019
    Posts
    56

    opening a worksheet to a standard view

    Hi,

    I am wondering if there is a way to have a worksheet open to a standard view everytime it is opened.

    I have a multipage workbook that numerous people will be entering and saving data into. I want to have the workbook open up onto a page with command buttons that will link to other pages. All of the other pages will be hidden until the command button is pressed.

    When they are done the workbook will be saved and closed. The next time the workbook is opened I would like it to open onto the page with command buttons and the other page(s) to be hidden once again.

    Is this possible?

    Deb

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: opening a worksheet to a standard view

    If they're using a macro to save and close, add some code to select the range that you want the workbook to open at, just before the workbook closes.

    Pete

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,465

    Re: opening a worksheet to a standard view

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...was-saved.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return to worksheet from backstage view, i.e. close backstage view or exit backstage view
    By freddyroosevelt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 12:44 AM
  2. VBA Opening Files protected view
    By Fean in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 12:37 PM
  3. Excel - Print To PDF. Set standard view?
    By Rosco88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2013, 05:32 AM
  4. View >> 'Bottum View' as standard at Startup of Outlook
    By Fschou in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-23-2012, 12:34 PM
  5. How to view a custom view when the worksheet is protected?
    By JulesJam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2006, 10:20 AM
  6. Opening in Form View
    By Ankeny JJ in forum Excel General
    Replies: 1
    Last Post: 03-02-2006, 08:10 AM
  7. My view has changed, I want same view as when opening excel
    By migalfarucci in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2005, 12:05 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