ActiveWindow.DisplayZeros = False
ActiveWindow.DisplayZeros = True


--
Regards,
Tom Ogilvy


"John Beschler" wrote in message
...
I am trying to change the option to show/not show zero valuesin an excel
workbook (or sheet) in VB 6.0. Can anyone point me in the right direction?
I've searched MSDN and google both, to no avail.

Thanks,
John