Mike,

Another thing you can do is add a button to the toolbar and assign a macro
to this button to turn the zero values on or off on a worksheet. The macro
that can do that is shown below. You put the macro in a hidden workbook that
excel opens anytime you start up excel (personal.xls). You can get to this
via Alt+F11 when in excel. You need to know how to customize or create a new
toolbar, add buttons, and assign macros.

Sub ZeroValues()
' ZeroValues Macro
' Turn zero values on or off for a worksheet
If ActiveWindow.DisplayZeros = True Then
ActiveWindow.DisplayZeros = False
Else
ActiveWindow.DisplayZeros = True
End If
End Sub

--
Tim Murphy


"WiFiMike2006" wrote:

Hello,

In Excel 2003, how can I hide zero values on all worksheets in a workbook,
and how can I set it up so that any new worksheet or workbook created has
zero values hidden?

Thank you,

Mike