XL2000: Can't Record "Open Published Web Page in Browser" Option (228894)
The information in this article applies to:
This article was previously published under Q228894 SYMPTOMS
When you select the Open published web page in browser check box in the Publish dialog box while recording a macro, Excel does not add the code that the macro needs to repeat this action. Therefore, when you run the macro, it does not open the page in the browser.
CAUSE
The Microsoft Excel object model does not currently support automatically opening a published page in a Web browser.
RESOLUTION
After recording the macro, modify the macro by adding the following code:
ActiveWorkbook.WebPagePreview
| Modification Type: | Major | Last Reviewed: | 9/25/2003 |
|---|
| Keywords: | kbdtacode kbmacro kbprb KB228894 |
|---|
|