I'm really struggling to find anything else to suggest.
Not sure what else to suggest.djikay, thank you a lot for this, now I'm able to identify where is the bad guy messing up my setting, and you're right, it is the regress that make the setting back to TRUE. Screen Updating = False before and after the regress statement, all screens are still flickering, any suggestions on that? Also, I read somewhere that having any watches active might cause a problem, so try removing any watches you may have and see if that makes any difference.
Worksheets(1) 'Find last cell with data in column A. It will then print off these and update any of the fields.
Visible = True here; but your code will 'run faster if you don't make it visible 'Open the workbook Set o WB = o XL. Open(File Name:=Workbook To Work On) Set o Sheet = o WB. Everytime it offsets it opens the cell value say c:\forms\travel expenses ; if travel expenses is in the cell.
Status Bar = "Please be patient..." Dim Rating As Variant, sht As Worksheet, Last Record Row As Long, i As Integer, Last Row As Long Rating = Input Box("Please Provide Weather Rating (Any Number Between 1 and 4)", "Input Needed") If Rating 4 Then Msg Box "Invalid Value, Please Enter A Valid Number!
I set it to False every time I use "select" or "activate", but it still not working, please help!! My macro is updating the field codes of the documents. When my macro runs i get a message Word is updating the field codes in the document. Then place the names of travel expenses in say D5 and training expenses in F5. Screen Updating = False" is commented out then _ This Workbook is active at the end of the procedure _ Else _ Book2is active at the end of the procedure Application. If I eliminate the commands involving Screen Updating from Test(), the workbook calling Test() is active when it completes, not Book2.The problem only occurs in Excel 2013- It does not occur in previous versions of Excel.