Karen

Personal.xls is created the first time you record a Macro using Macro
Recorder.

ToolsMacroRecord New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing/copying them into the
Module.

You can do a FileSave from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit WindowHide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

NOTE: when assigning macros to buttons or menu items you will have to precede
the macro name with Personal.xls.

i.e. Personal.xls!macroname

An alternative to Personal.xls is to create an add-in(*.xla) with your macros
in it and load it through ToolsAdd-ins.

The benefit of this is that you don't have to precede the macro name with the
filename.

A disadvantage is that you will not see the macros in the ToolsMacroMacros
dialog.


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 13:15:17 -0800, "Karen"
wrote:


I fine with every instruction, I just can't find
the'Personal.xls' to highlight when I'm in the Visual
Basic Editor - HELP

-----Original Message-----
I think you're going to need to creaet a couple of
custom buttons and macros.
In your 'Personal.xls' workbook, insert a module.
TOOLS / MACRO / VISUAL BASIC EDITOR
then
** Highlight 'Personal.xls'
then
INSERT / MODULE

In that module, copy the following code...

'/============================/
Public Sub MySubscript()
With Selection.Font
.Superscript = False
.Subscript = True
End With
End Sub
'/============================/
Public Sub MySuperscript()
With Selection.Font
.Superscript = True
.Subscript = False
End With
End Sub
'/============================/

Now, put 2 buttons on your 'Formatting' toolbar (or
whereever).
Right-click in the toolbar area and select 'Customize'.
Under 'Categories', scroll down to 'Macros'. In
the 'Commands' window,
left-click on the smiley face and drag it up to
whereever in the toolbar area
you want.
Right-click on the button. In the Name box, put
SUPERSCRIPT.
Left-click on 'Assign Macro' and select 'MySuperscript'
then select 'OK'.
Select 'Close'.
Repeat for the SUBSCRIPT macro.


- - - - - - - - - - - - - - - - - - - - -
**Note: If you don't see 'Personal.xls', go back to
your workbook.
TOOLS / MACRO / RECORD NEW MACRO
In the 'Store Macro In' dropdown box, select 'Personal
Macro Workbook'.
Select 'OK'. The Macro button should appear. Now move
the cursor and click
on the macro button to stop the macro recording.
What this has done is simply to create 'Personal.xls'.
By the way, next time you record a new macro, remember
to change back from
'personal Macro Workbook' to 'This Workbook'.
- - - - - - - - - - - - - - - - - - - - -

Hope this helped.
Gary Brown


"Karen" wrote:

Is it possible to add a subscript & superscript icon
to
the tool bars? I cannot find it under the "Customize"
menu.

HELP

.