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

Maybe you could use a userform to display the help:

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

Tony McGee wrote:

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

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

Thisworkbook.worksheets("myHelpSheet").copy

(called from within your addin)

Regards,
Peter T


"Tony McGee" wrote in message
...
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

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.

--
Regards,
Tom Ogilvy

"Tony McGee" wrote in message
...
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