Excel 2016 screenupdating not working

excel 2016 screenupdating not working-14

I am just a beginner with Excel VBA I would highly appreciate any help. Column Case Is = 4 'This column contain invoice number 'Take the user to Invoice input form to edit the invoice they just double-clicked on a = Active Cell.

The following code intercept where the user double click on the sheet and show them to the corresponding sheet.

Do not believe these claims — they are misinformed and dead wrong.

Whenever you set Screen Updating to False in your code, make certain to reset it to True.

Supporters of this claim mistakenly believe that VBA “resets itself” at the end of a macro or procedure, and/or not resetting Screen Updating to True has no bad effects.

Last modified 21-Jun-2016 15:43