PDA

View Full Version : Excel VBA code to change the User Interface to default view upon opening



LeoLee
11-16-2011, 01:23 PM
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! :bow:

Leo

mikerickson
11-16-2011, 01:47 PM
It sounds like a Custom View would do what you want.