Hide Zeros Macro

[Max Scott]

Hi

Is it possible to macro the "Excel Options - Advanced - Show a Zero in Cells
that have a zero value" option in Excel 2007?

Thanks

Max

 

[Bob Phillips]

Turn the macro recorder on and record it.