VBA Screenupdating for a certain range.

[Subzaltys]

Hi All,

I have a VBA code at the moment that causes a certain column (I can't make it only do a range) to save the previously altered value of another column whenever it is updated.
However I only want these updates visually to happen when a certain milestone occurs in real life, so I think the easiest way to do that is to have ScreenUpdating attached to a dropdown selection being changed, or an ActiveX button or checkbox. This would require the ScreenUpdating code to only affect a certain range which I don't know is possible.

Can anyone help or does anyone know a better way of achieving this? Or am I wanting something impossible?

Thanks,
Reuben

 

[offthelip]

Welcome to the forum, one easy way to "hide" values is to change the font of the values to white, this means that you can update the values in the columnm and they don't appear, you can then make them appear by changing the formatting, try these two macros:

Sub Hide()
     With Range("D4:D12").Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
End Sub
Sub unHide()
     With Range("D4:D12").Font
        .ThemeColor = xlThemeColorLight1
        .TintAndShade = 0
    End With
End Sub