Weird error adding custom help file to user defined function in Excel 2007

sabotuer99

New Member
Joined
Jul 19, 2008
Messages
4
I created a function in VB and wanted to add a help file, so that when you
pull the function up in "insert function" you could click on "help with this
function" it pulls up the function. After some digging I discovered how to
do this:

right click "VBAProject (MyAdd-in)"
VBAProject Properties...
Help file name (browse to help file)
assign context id

Then, in the code window,
bring up object explorer (F2),
navigate to my function,
right click, select "Properties...",
and enter context id assigned above.
(Note at this point that the "Help File" field, which can't be edited,
contains the same file location entered in the VBAProject Properties above...)

save project, flip back to excel, insert function, find mine, click "help
with this function" and viala it works.

Now the weirdness starts.

When I close and reopen excel, try to click "help with this function" again
and I get this error:

"Cannot open the file: mk:MSITStore:C:\Program Files\Microsoft
Office\Office12\????."

So I try everything I can find about this error (.ocx files, reregistering,
MJ's Tools, etc.) and nothing works.

When I navigate back to VBAProject Properties, the help file address is
still fine.
However when I go to the properties for my function, the "Help File" field
now reads "????" instead of the help file from VBAProject Properties.

So I go back to VBAProject Properties and enter "test" in the help file
field. I check my function and "Help File" now reads "test". I save and go
back to excel. Try clicking the link and low and behold I get this error:

"Cannot open the file: mk:MSITStore:C:\Program Files\Microsoft
Office\Office12\test"

So when I reload excel it is corrupting the address for the help file for my
function and apparently the only way to resolve it is to load and resave in
VBA everytime I open excel (not exactly convenient)

So how does one get word to MS that there is something screwed up in excel?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,216,040
Messages
6,128,454
Members
449,455
Latest member
jesski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top