Consulting

Results 1 to 2 of 2

Thread: Excel VBA code to change the User Interface to default view upon opening

  1. #1
    VBAX Regular
    Joined
    Jan 2011
    Posts
    30
    Location

    Excel VBA code to change the User Interface to default view upon opening

    Hi People,

    Currently, I am helping my Mom to pick up simply Excel usage. As my Mom is very new to computer, she will panic whenever she screw up the User Interface display.

    However, my VBA knowledge is quite limited and would appreciate if anyone could assist me on this.

    Is there a VBA code that I can reset the User Interface View to a default view just like how we first started out our excel workbook fresh? I have attached a picture of an example of what I am trying to achieve.

    In the picture, the left side is an example of how my Mom would miss click and screw the user interface.

    The right side of the picture is what I would like to achieve by:
    Creating a VBA button that whenever she click it, the user interface would jump back to the default view or whenever she close and re-open the excel workbook again.

    Would appreciate if anyone could assist me on this matter and thank you for your time!

    Leo
    Attached Images Attached Images

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    It sounds like a Custom View would do what you want.

Posting Permissions

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