Forum Discussion
Excel Display Issue When Working w/ Multiple Sheet & Macro Enabled Woorkbook
Hi, I have 39 different worksheets in one excel file and I have simple VBA codes that basically hides/unhides or protects chosen worksheets. When I try to calculate one formula (Basically cha...
I solved the problem. For every VBA code that I have & within ThisWorkbook/WorkSheetChange Module, I disabled ScreenUpdating, AlertBeforeOverwriting & DisplayAlerts by using the code I showed before. With this way, the distortion disappeared. Thanks for your time.
Matt12032 Excellent. Sorted then.