ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run an HTA as an embedded object in a sheet for help (https://www.excelbanter.com/excel-programming/400410-run-hta-embedded-object-sheet-help.html)

XP

Run an HTA as an embedded object in a sheet for help
 
Using Office 2003 and Windows XP;

I would like to write a help file in an HTA and then embed that as an icon
in an Excel sheet. I tried this on a test basis using the following function:

Sub Test_this()
Worksheets("HelpSheet").OLEObjects("HelpFile").Act ivate
End Sub

This opens the HTA, but I get two security warnings when doing so, which is
rather annoying for a "Help" file. Is there a work around for using an HTA?

I know PDF will work, but that gets into other issues, such as versions,
where they are installed etc.

Thanks much in advance.



All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com