Prev: Auto sorting to match
Next: Can't lock cells
From: Grey Old Man on 5 May 2010 15:07
Does anyone have any experience of creating documentation accessible through
the Excel Help menu item?

I have successfully created a series of Excel 2002 templates and wish to
create a user guide for them. My work environment prohibits downloads or
specialised software, so RoboHelp, etc is not an option.

My initial thoughts are to write a macro that opens a Word document full of
hyperlinks. Has anyone been more creative?

Thanks in anticipation.
From: CLR on 5 May 2010 15:17
I frequently create "Menu Sheets" for my Excel applications. Using Drawing
Objects and/or icons and assigning macros to them. No need to go to Word.

Vaya con Dios,
Chuck, CABGx3





"Grey Old Man" wrote:

> Does anyone have any experience of creating documentation accessible through
> the Excel Help menu item?
>
> I have successfully created a series of Excel 2002 templates and wish to
> create a user guide for them. My work environment prohibits downloads or
> specialised software, so RoboHelp, etc is not an option.
>
> My initial thoughts are to write a macro that opens a Word document full of
> hyperlinks. Has anyone been more creative?
>
> Thanks in anticipation.
From: Grey Old Man on 5 May 2010 15:53
Sorry, not sure what you mean by "Menu Sheets" and "Drawing Objects". What
format are they in?
I am OK assigning macros to custom menu items.

I put together "a few notes" to create a draft Word user guide, but this
(with screen captures) is already 50 pages!



"CLR" wrote:

> I frequently create "Menu Sheets" for my Excel applications. Using Drawing
> Objects and/or icons and assigning macros to them. No need to go to Word.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
> "Grey Old Man" wrote:
>
> > Does anyone have any experience of creating documentation accessible through
> > the Excel Help menu item?
> >
> > I have successfully created a series of Excel 2002 templates and wish to
> > create a user guide for them. My work environment prohibits downloads or
> > specialised software, so RoboHelp, etc is not an option.
> >
> > My initial thoughts are to write a macro that opens a Word document full of
> > hyperlinks. Has anyone been more creative?
> >
> > Thanks in anticipation.
From: Chip Pearson on 5 May 2010 16:43
There is nothing in Excel or Office that facilitates the creation of
help files. You could write the help as a Word document and then
create a PDF from that, using Adobe or compatible software. If you
really want to do it right, you'd need a dedicated help system
authoring/editing application. I use Help & Manual 5 for creating help
files and find it very easy to use.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Wed, 5 May 2010 12:07:01 -0700, Grey Old Man
<GreyOldMan(a)discussions.microsoft.com> wrote:

>Does anyone have any experience of creating documentation accessible through
>the Excel Help menu item?
>
>I have successfully created a series of Excel 2002 templates and wish to
>create a user guide for them. My work environment prohibits downloads or
>specialised software, so RoboHelp, etc is not an option.
>
>My initial thoughts are to write a macro that opens a Word document full of
>hyperlinks. Has anyone been more creative?
>
>Thanks in anticipation.
From: Dave Peterson on 5 May 2010 20:10
This may not work for you.

John Walkenbach shows a way to use a userform to display text kept in a
dedicated worksheet:
http://spreadsheetpage.com/index.php/tip/C29
(look for "Displaying Help")

I've found that nobody but me will read the help that I wrote anyway. So I
wasn't going to invest time in learning how to create that .hlp/.chm stuff.

You may want to create the word document for your own use and distribute a copy
to your users. But I don't think that will stop the phone calls <vbg>.

Grey Old Man wrote:
>
> Does anyone have any experience of creating documentation accessible through
> the Excel Help menu item?
>
> I have successfully created a series of Excel 2002 templates and wish to
> create a user guide for them. My work environment prohibits downloads or
> specialised software, so RoboHelp, etc is not an option.
>
> My initial thoughts are to write a macro that opens a Word document full of
> hyperlinks. Has anyone been more creative?
>
> Thanks in anticipation.

--

Dave Peterson
 | 
Pages: 1
Prev: Auto sorting to match
Next: Can't lock cells