Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Excel model with several VBA macros that I have been maintaining in
Excel 2003 for years with no issues. I recently updated to Office 2007, made some adjustments to the model, and it works fine on my machine (and fine on some of my coworkers' machines). However, the exact same file when run on other coworkers' machines is having issues where the "Application.screenupdating" is being set to true whenever the code switches worksheets or workbooks. For example: Sub ProcessName() Application.Screenupdating = FALSE Sheets("Sheet 1").Range("Range 1").clearcontents Sheets("Sheet 2").Range("Range 2").clearcontents 'Up to this point, Screenupdating=FALSE on ALL machines Sheets("Sheet 3").Select 'At this point, Screenupdating=FALSE on some machines and TRUE on others Range("Range 3").Select Selection.Validation.Delete Application.Screenupdating = TRUE End Sub Again, when running on some machines - no problem (screenupdating remains set to false at all times), but when run on another machines, it switches to true. We all are running Office 2007. I have seen many posts on various forums regarding similar issues, but nothing regarding screenupdating working on one machine but not another. Is there an Excel Options setting that could be different between our machines that could be causing this? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
screenupdating=false not working | Excel Programming | |||
Screenupdating=false not working | Excel Programming | |||
'Application.ScreenUpdating = False' isn't working | Excel Programming | |||
ScreenUpdating = False not working | Excel Programming | |||
ScreenUpdating = False not working | Excel Programming |