When I have used ActiveWorkbook.PublishObjects.Add, a viewer of the .html file has the option of changing the data, via Microsoft Internet Explorer.

If the .html file’s attributes are set to Read-only, which I have done manually for test purposes, the next time I execute the procedure, ActiveWorkbook.PublishObjects.Add dies with a Run-time error ‘1004’, and that makes sense.

Is there a way, in VBA, to suppress the “File=>Edit with Microsoft Excel” option when using Microsoft Internet Explorer yet still enabling update via VBA?

Thank you for the time you spent trying to understand my problem, and any solutions you may offer.