Solved

Change default Opttions in Excel

Posted on 2011-02-22
3
272 Views
Last Modified: 2012-05-11
Hello,

In Excel (2007), is there a way to change the default settings for how new workbooks open?  

For example, in Office Button > Excel Options > Advanced > Display options for this workbook, there is a checkbox labeled "Show horizontal scroll bar."  Currently, new workbooks open with this box checked.  Is there a way to change that so that the default setting will have this box unchecked?

Thanks
0
Comment
Question by:Steve_Brady
  • 2
3 Comments
 
LVL 10

Expert Comment

by:shahzadbux
ID: 34953703
0
 
LVL 45

Accepted Solution

by:
patrickab earned 500 total points
ID: 34953739
Steve_Brady,

Place this in the ThisWorkbook VBA code pane of an existing file:

Private Sub Workbook_Open()
ActiveWindow.DisplayHorizontalScrollBar = False
End Sub

Save and close the file then reopen it and the HorizontalScrollBar should not be visible.

Patrick
0
 
LVL 45

Expert Comment

by:patrickab
ID: 35074263
Steve_Brady - Thanks for the grade - Patrick
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question