View Single Post
Old 06-12-2019, 12:09 AM
OldGuy is online now
Charter Member
Join Date: Dec 2002
Location: Very east of Foggybog, WI
Posts: 5,335
I assume you know that "hide all zeroes" works a the sheet level and not workbook level so you must hide them for each sheet. And I assume you're doing the 2003 equivalent of
in Display options for this worksheet:
untick "show a zero ...."

That is saved for me and applied on a reopen.

And I assume you are saving the file and it is nor write protected.

If you still can't get it to work, you might try writing a macro that runs automatically upon opening the workbook. I'd think you could record the steps you want, then put the the commands

Sub Auto_Open()

End Sub

around the actual commands you want executed in the Visual Basic section

Last edited by OldGuy; 06-12-2019 at 12:10 AM.