Hi All, I've got the below code which runs from wb1, opens wb2 and then saves that wb as read-only. However, there are some links inside which mess things up if a user decides to enable updates.
wb2.SaveAs fileName:=filePath & "\" & fileName & ".xlsx", ReadOnlyRecommended:=True
Is there a way to make it so that wb2 never even triggers that pop up so that the file just stays as read-only and never changes?
Perhaps adding to workbook.open event something along the lines of:
Application.AskToUpdateLinks = False
Application.DisplayAlerts = False
Many thanks!