Displaying help for an addin

T

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
 
P

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top