Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Excel VBA you can activate What's This Help (that uses the ? icon in
the top of a form) by specifying the help file path in the Help File Name field on the General tab of Project Properties and then assigning help context ID's to the various form controls (while also setting the form's WhatsthisButton and WhatsThisHelp properties to true). This works fine as long as you use WinHelp 4 and not HTML help and you can change the help file path in the the Project Properties programmatically with Application.ThisWorkbook.VBProject.Helpfile = MyHelpfilepath. All is OK until you Lock the Project for Viewing in the the Protection tab of the project properties. The call to the VBProject.Helpfile property then produces an error as locking the Project protects the Project properties. Does anyone know a way around this? (Note: I am aware that you can use the Application.Help method to access HTML help files from form controls but I am wanting to implement the Whats This Help specificaly). Thanks in advance, Seisman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Setiiing up file name & path as a default setting on all sheets/ta | Excel Discussion (Misc queries) | |||
Setting Printer Options Programmatically | Excel Programming | |||
Setting the Help 4.0 file name and path in a locked project | Excel Programming | |||
whatsthishelp | Excel Programming |