Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to add help to the template
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to add help to the template
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to add help to the template
Thank you very much for your suggestion. It works exactly as I wanted it to be.
Tony "Sharad" wrote: 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to add help to the template
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 "Sharad" wrote: 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to add help to the template
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 "Tony" wrote: 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 "Sharad" wrote: 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
How can I link between a Word template and an Excel template | Excel Discussion (Misc queries) | |||
Automatically look in template folder when one opens a template | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |