Tweak macro to toggle fixed decimal.

[dianemarie]

Hello, I often go back and forth between using fixed decimals. The recorded macro to turn on the fixed decimal option looks like this (minus comments):

Sub ToggleDecimal()
Application.FixedDecimal = True
End Sub

I had it set up to toggle back and forth but I just got a new hard drive and I can't remember how it's done. I know it was easy, I got the code from a book. Anyone know how? Thank you.

 

[TonyJollans]

Hi dianemarie,

There are various ways of doing it but this is probably the easiest ..

Application.FixedDecimal = Not Application.FixedDecimal

Enjoy,
Tony

 

[dianemarie]

Thank you Tony, works great. I had to put it one line though, to get it to work.