what is the best way to add help to the template

[Guest]

I have created the Excel template. I would like to add the custom help
explaining different functions and their usage. What is the best way to add
help to mu template. I am thinking about creating PDF file to be activated
from the custom toolbar or by pressing key (associated with macro which will
open the PDF file). But because I am planning to distribute the template on
CD and will not know the letter associated with the CD drive I may have a
problem with specifying the path for my PDF help file. Some users may not
have the Acrobat Reader installed on their systems too. The best way will be
to attach the custom help file which will make part of the template. How to
do it ? In what form ?

Thanks for advice.

Tony

 

[Sharad]

You can add a help file as an embedded object in to the template.
It will be still better to add a PDF file, it occupies less space and
users will not be able to change its contents. Today, every tom dick and
harry
has Adobe Actrobat Reader.

Anyway you can decide whether you want to add a PDF file or say a word
document.
Create the help file and save.
In your excel template add one sheet change the sheet name to say
'Help-Sheet'.
Activate this sheet, click on 'Insert Menu' and chose 'Object'.
In the Object window click on 'Create from File' tab.
Browse and point to your help file.
DO NOT check 'Link to File' box.
Check 'Display as Icon' box.
Click OK.
The file icon will appear in the sheet.
Single click on it. In the excel name box its name will appear as
Object1.
Change it to say "Help-File" and press enter.

Hide sheet 'Help-Sheet'.

Now in your custom toolbar button code, add following code
Sub yourbutton_Click()
Worksheets("Help-Sheet").OLEObjects("Help-File").Activate
End Sub

Sharad

 

[Guest]

Thank you very much for your suggestion. It works exactly as I wanted it to be.

Tony

 

[Guest]

I was a bit too quick saying that all is working fine. When I am executing
the line:

Worksheets("Help-Sheet").OLEObjects("Help-File").Activate

I am getting the error message:

Run-time error '1004'
Application-defined or object-devined error

Any reason and solution for it ???

Regards,

Tony

 

[Guest]

I have tested it again and all is working find. It had to be something with
my typing or something. Once again thank you for your help.

Tony