Macro issue due to pop up message

Hi everyone,

I've written a code to click on hyperlinks in my excel spreadsheet and subsequently save those hyperlinked excel spreadsheets in local folder before closing them. These spreadsheets are links within a website.

However, on first instance, I always encounter a pop up message as shown below and the macro could not proceed further. I've tried "Application.DisplayAlerts = True" but doesn't seem to work.

Thus would like to ask the community for help please. Thank you!

Capture.PNG

Hi there,

I've tried "Application.DisplayAlerts = True" but doesn't seem to work

Shouldn't that be

Please Login or Register  to view this content.

Regards,

Greg M

Hi Greg,

Here's a extract of my code. I will change both to false but the same message box still pop out.

Range("I34").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _

"<\FOLDER\final excel >" & Format(Date, "DD MMM") & ".xls", FileFormat:= _
xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Application.DisplayAlerts = True
ActiveWindow.Close