What is application screenupdating
Those will be used to set the default file name and folder.A time stamp will be added to the default name, in the format yyyymmdd_hhmm.Name, " ", "") str Name = Replace(str Name, ".", "_") 'create default name for savng file str File = str Name & "_" & str Time & ".pdf" str Path File = str Path & str File 'use can enter name and ' select folder for file my File = Application.Get Save As Filename _ (Initial File Name:=str Path File, _ File Filter:="PDF Files (*.pdf), *.pdf", _ Title:="Select Folder and File Name to save") 'export to PDF if a folder was selected If my File "False" Then ws A.Display Status Bar = True With Worksheets(“Sheet1”) lrow = .Screen Updating = False at the beginning of your code, then if any user runs the code, they will not know what is going on and think that the computer system is not responding.If you have turned off screen updating using the line Application.
New Window ' Unlock the window to start refreshing again Screen Updating = True Exit Sub Err Handle: If Err.
All other users do not get this prompt, the file just saves and closes.
I looked online for updates that cover this behavior and found nothing relating to this problem.
Screen Updating) are returning an error: Application.
Screen Updating = True THe error is Compile error, Method or data member not found Anyone has a clue what the problem is?
Right click the sheet tab that you want to follow the hyperlink to hidden sheet, and then choose View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module: Private Sub Worksheet_Selection Change(By Val Target As Range) 'Updateby Extendoffice 20161109 Application.