Put it in your Personal.xls workbook.

--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
Yesterday I found the proper name case module in this discussion thread.
It
works, however I am having a hard time when I try to run this module on
different spreadsheets. Is there a way that I can save the module and
pick
it up and use it when I need to (kind of like a macro)? Any help would be
greatly appreciated !!

Thanks for any help in advance.

OK, can you explain that a bit further, I am really new to the modules.
Thanks !!!

"Bob Phillips" wrote:

Put it in your Personal.xls workbook.

--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
Yesterday I found the proper name case module in this discussion thread.
It
works, however I am having a hard time when I try to run this module on
different spreadsheets. Is there a way that I can save the module and
pick
it up and use it when I need to (kind of like a macro)? Any help would be
greatly appreciated !!

Thanks for any help in advance.

if you have the workbook open that currently contains the module, in
the VBA editor you will see the name of that workbook, and the name of
"Personal.xls". drag the module to the personal.xls & it will place a
copy there. if you want, delete the original from the first workbook.
then, in the excel workbook, right click up in the toolbars and choose
"customize". under "commands" go to "macros" & you will see a yellow
smilie face called custom button. drag that up into your toolbars
wherever you want it. right click the new yellow smilie face and
"assign macro", choosing the one in the personal.xls. then click
"close".
now that button will run that macro whenever you click on it.

if you don't see personal.xls, that means one hasn't been created
yet. record a simple macro & choose that it be stored in your
personal.xls, and that will create it. you can always delete the
simple macro afterwards.

again, post your code if it needs to be made more general (without
specific sheet names, etc.).
hope that helps
:)
susan



On Jul 31, 9:10*am, Kelly wrote:
OK, can you explain that a bit further, I am really new to the modules. *
Thanks !!!



"Bob Phillips" wrote:
Put it in your Personal.xls workbook.

--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
Yesterday I found the proper name case module in this discussion thread.
It
works, however I am having a hard time when I try to run this module on
different spreadsheets. *Is there a way that I can save the module and
pick
it up and use it when I need to (kind of like a macro)? *Any help would be
greatly appreciated !!

Thanks for any help in advance.- Hide quoted text -

- Show quoted text -

Personal.xls is located in the XLStart directory, and is used to store
macros and
things that you want to be available to all workbooks, whenever you start
Excel.

You can create it by
- goto ToolsMacrosRecord New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (WindowsUnhide)


--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
OK, can you explain that a bit further, I am really new to the modules.
Thanks !!!

"Bob Phillips" wrote:

Put it in your Personal.xls workbook.

--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
Yesterday I found the proper name case module in this discussion
thread.
It
works, however I am having a hard time when I try to run this module on
different spreadsheets. Is there a way that I can save the module and
pick
it up and use it when I need to (kind of like a macro)? Any help would
be
greatly appreciated !!

Thanks for any help in advance.

See also
http://www.rondebruin.nl/personal.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelly" wrote in message ...
OK, can you explain that a bit further, I am really new to the modules.
Thanks !!!

"Bob Phillips" wrote:

Put it in your Personal.xls workbook.

--
__________________________________
HTH

Bob

"Kelly" wrote in message
...
Yesterday I found the proper name case module in this discussion thread.
It
works, however I am having a hard time when I try to run this module on
different spreadsheets. Is there a way that I can save the module and
pick
it up and use it when I need to (kind of like a macro)? Any help would be
greatly appreciated !!

Thanks for any help in advance.