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 files 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.