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