As title, because in the code needs to be read only open another form a excel file and copy some of the content, but in the open form, because the target form some external links, will be displayed: to this workbook contains one or more may not be safe source of external links

Every time I need to manually click update options can not continue to steps, so want to ask how can skip this step?

 Application. ScreenUpdating=False 
Sheets (" XXXX "). Select 
The Columns (A: "G"). Select 
Selection. ClearContents 

Dim bok As Workbook 
The Set bok=Workbooks. Open (XXXXXXXXXXXXXXXXX \ "Cross Support Name List. XLSM", ReadOnly:=True) 'Open the workbook in a read-only way, 

Windows (" Cross Support Name List. XLSM "). The Activate 
Sheets (" CrossSkill "). Select 
Range (" E7). Select 
Selection. The AutoFilter 
ActiveSheet. Range (" $A $7: $O $199 "). The AutoFilter Field:=6, Criteria1:="EU" 
Range (" C7: I1000 "). Select 
Selection. Copy 
Windows (" Automatic Attandance Tool - 20191218. XLSM "). The Activate 
Range (" A1 "). Select 
ActiveSheet. Paste 

CodePudding user response:

Baidu search how to find the excel external links, delete him

CodePudding user response:

https://jingyan.baidu.com/article/5d368d1ec776c23f61c0575f.html

CodePudding user response:

reference 1/f, crispy big ice cream reply:

baidu search to find excel external links, delete him

It was the external links can't delete...

CodePudding user response:

refer to the second floor response: VB amateurs

https://jingyan.baidu.com/article/5d368d1ec776c23f61c0575f.html

The requested page has been deleted -_ -!!!

May this link have failed

Return to the home page
After 5 seconds automatically return

CodePudding user response:

reference 1/f, crispy big ice cream reply:

baidu search to find excel external links, delete him

Precisely the table is not I maintain, I don't have permission to operate

CodePudding user response:

You in baidu search "this workbook contains one or more external source link may not be safe", not delete external links, just close the warning

CodePudding user response:

refer to 6th floor response: VB amateurs

you in baidu search "this workbook contains one or more external source link may not be safe", is not delete the external links, just close the warning

That makes sense... Let me try

CodePudding user response:

Application. DisplayAlerts=False disables display and warning messages; When there is a need to users to reply message, Microsoft Excel to select the default response,