Mike,

The view tab is only for the worksheet you editing. I apologize for the
misinformation. You can select multiple worksheets at one time by holding
down the Ctrl or Shift key as you select worksheets. Then when you go to the
view tab any changes you make occur on all worksheets. However, changing the
view tab doesn't setup defaults for the workbook or new workbook. I searched
the discussion groups and didn't find an answer for this, nor do any of my
excel books talk about this.
--
Tim Murphy


"WiFiMike2006" wrote:

Ok. So how do I set up the default values for workbooks?

Thanks,
Mike

"vttanker" wrote:

Mike,

Go to ToolsOptions. On the View tab there is a checkbox call Zero Values.
If you uncheck the box any zero value will disappear. This will affect any
workbook you open regardless of the previous settings. You can also setup
many other default settings for your workbooks when they open and when you
add worksheets.
--
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