Displaying help for an addin

[Tony McGee]

I have written an addin which works OK. It inserts a new menu into Excel to
do it's stuff.

However, I have a "Help" sheet within the addin file. Can I & if so, how do
I call this from my menu to display my addin help worksheet from within any
Excel file once the addin is installed.

Thanks
Tony McGee

 

[Dave Peterson]

Maybe you could use a userform to display the help:

http://j-walk.com/ss/excel/tips/tip51.htm
from John Walkenbach's site.

 

[Peter T]

To add a new workbook with a copy of your help sheet -

Thisworkbook.worksheets("myHelpSheet").copy

(called from within your addin)

Regards,
Peter T

 

[Tom Ogilvy]

Another idea.

In your addin, code that does

Thisworkbook.Worksheets("Help").Copy

should put it up as a new workbook with a single sheet - your help sheet -
kind of a help window.