Excel 4.0 Macros over the network doesn't work

Visitor

When I open Excel 4.0 Macro using "Workbooks.open () RunAutoMacros" over the network, the file gets corrupted.

 

Workbooks.Open(Filename:= _
'\\FileServer\ShareFolder\SubFolder\WithExcel4.0MacroSheet.xls').RunAutoMacros _
Which:=xlAutoOpen

 

 

It worked fine a few months ago, but I've been having this problem ever since.

 

   - I referred to the internet information and tried the following, but it doesn't improve.

   - Add a folder on the network to Excel Option> Trusted Locations
   - Latest version of Microsoft 365 [version 2008 (build 13127.20508)]
   - Revert Microsoft 365 to the previous version [version 2002 (build 12527.20278)]
   - Stop virus software

    * My PC: Windows10 Pro version 2004 (build 19041.508)

 

I'm guessing that Microsoft's update has added security restrictions, but I don't know the solution.

Thank you in advance for any suggestions or assistance!

0 Replies