Macro for toggle zero value display

[husoi]

Hello everyone.

Just wanted to share a macro I created that will toggle the display zero values.

It is a very simple code that will change the display of zero values.
I created a button in the ribbon that will access the macro so I just need to press it instead of going to all the trouble (not much I know) to change the zero value being shown or not.

Sub zero_value()
'
' Toggle zero value display Macro
' Macro Created 09/03/2020 by Husoi

If ActiveWindow.DisplayZeros = True Then
ActiveWindow.DisplayZeros = False
Else
ActiveWindow.DisplayZeros = True
End If

End Sub

Enjoy it

 

[CephasOz]

Hi Husoi. Good stuff - does what you need it to do, and doesn't have any side-effects. Could I make a suggestion, though? When you are doing toggles (flipping a Boolean value from one state to its opposite) a common technique is to use NOT, such as:

Sub zero_value()
    ActiveWindow.DisplayZeros = Not ActiveWindow.DisplayZeros
End Sub

 

[Fluff]

You can simplify that like

Sub ShowZeros()
   ActiveWindow.DisplayZeros = Not ActiveWindow.DisplayZeros
End Sub

 

[husoi]

Cool, guys,

thank you for the info.
This only shows that there is always an easy way..
But I don't go about the easy way isn't

 

[Fluff]

Glad we could help & thanks for the feedback

 

[CephasOz]

That goes for me too.