Hi All, not sure if this is even possible but I'm trying to save a file from another workbook and then ensure that nobody can update any links in it, etc. upon opening, and so I'd need to insert the below two lines of code under 'Workbook_Open' but I'm unsure how to this, so I'd greatly appreciate some help.
This is my save as line:
Many thanks!
VBA Code:
Application.AskToUpdateLinks = False
Application.DisplayAlerts = False
This is my save as line:
VBA Code:
wb2.SaveAs fileName:=filePath & "\" & fileName & ".xlsm", ReadOnlyRecommended:=True
Many thanks!