keith.b
02-08-2012, 10:07 AM
I tried the code from the post 'Hide the Zeros' by johnske, and also the accompanying test program in 'KillZeros.zip' (uses 'ActiveWindow.DisplayZeros = False' in ThisWorkbook / Sub Workbook_SheetActivate).
Whilst they work when opening my programs, and in the test program, if I open a New Window (Excel 2007) whilst the original is still running, zero's are not suppressed on the first sheet of the new window. On changing sheets, zero's are displayed momentarily before clearing. Upon returning to the first sheet, they are again displayed momentarily, before clearing.
How can I avoid these zeros showing at all?
Thanks!
PS. I don't have the date of the post referred to, found it through Google, and no historical information was available. It was approved by 'mdmackillop'.
Whilst they work when opening my programs, and in the test program, if I open a New Window (Excel 2007) whilst the original is still running, zero's are not suppressed on the first sheet of the new window. On changing sheets, zero's are displayed momentarily before clearing. Upon returning to the first sheet, they are again displayed momentarily, before clearing.
How can I avoid these zeros showing at all?
Thanks!
PS. I don't have the date of the post referred to, found it through Google, and no historical information was available. It was approved by 'mdmackillop'.