Dave,

More or less related:

Every time I open a new wokbook zeros will be visibly represented, so I
always have to uncheck that option in toolsoptions etc.

In C:\program files\microsoft office\office\xlstart I put a "map1.xls" of
which all sheets have the zeros option unchecked. When I start Excel that
map.xls pops up, as expected, but for every extra sheet in that workbook and
any new workbook I open the zeros option has to be unchecked again.

I simply want every new sheet of every new (and preferably also excisting)
workbook to have the zeros option unchecked by default.

What should I do to accomplish that?

Jack Sons
The Netherlands

"Dave Peterson" schreef in bericht
...
Saved from a previous post:

Excel tries to help by remembering the last settings you used--except for
the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way
you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=True

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to
get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Brian wrote:

When I execute Edit then Find, Excel begins to search by row. Can anyone
suggest how:
(a) to directly change this default or
(b) to incorporate a few lines of VBA codes
so as to make it search by column without having to select Options first,
and change the search command to "By Column"?
Thank you for your help.

Brian

--

Dave Peterson