LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default MyHelp - VBProject.Helpfile

Having trouble getting helpfiles to work

1) How do we specify VBProject.Helpfile to point to the same folder as the
installed addin?
We have tried:
VBProject.Helpfile = ThisWorkbook.Path & "\MyHelp.chm"

but we get VBA access not trusted error (424 object required), If I allow
trusted acces to VBA it's goes thru however , I have to tell all my useres
to allow VBA trusted access in Macros Security.

2) ThisWorkbook.VBProject.Helpfile returns ???? until I set it locally using
the Project properties, this occurs when moving the xla from one machine to
another, on the first machine it is set to "MyHelp.chm", but when i try and
read it on another machine it retruns ????.

we need this so when the user hits F1 on a VBA userform, it pulls up the
right help file. also when the function wizard displays "get help of this
functions" to point to our helpfile. I think we can get round the function
wizard with application.MacroOptions, but not F1 on Userforms.





 
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
Open Helpfile from Excel VBA or hyperlink Thijs Hessels Excel Programming 0 September 30th 04 08:57 AM
Unprotecting the VBProject jstrater Excel Programming 4 May 16th 04 04:01 PM
Documentation for VBProject Wes Jester Excel Programming 2 September 30th 03 06:26 PM
VBProject events? Marc R. Bertrand Excel Programming 1 September 14th 03 04:12 PM
Unable to launch html helpfile RB Smissaert Excel Programming 0 July 19th 03 01:49 AM


All times are GMT +1. The time now is 02:11 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"