LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default WhatsThisHelp in VBA - setting the help file path programmatically

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula too long - new file path is shorter than old file path - Excel 2003 Greg J Excel Worksheet Functions 1 November 22nd 06 05:16 PM
Setiiing up file name & path as a default setting on all sheets/ta Paul Canal Excel Discussion (Misc queries) 3 March 31st 06 01:07 PM
Setting Printer Options Programmatically Chaplain Doug Excel Programming 0 December 16th 04 09:35 PM
Setting the Help 4.0 file name and path in a locked project Tony C[_3_] Excel Programming 5 November 13th 04 04:15 PM
whatsthishelp Al Ram Excel Programming 0 November 3rd 04 02:41 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"