short cut key reqired

[Anil showreddy]

HI all,

Can you give me a shortcut key for
"move a selected sheet from one book to another book" and
"To increase or decrease the font size in cell"

Thankyou..

 

[Gary''s Student]

To increase the font size, insert the following sub:

Sub fontbump()
ActiveCell.Font.Size = ActiveCell.Font.Size + 1
End Sub

and assign CNTRL-e to it.


In general, if a shortcut key has not been assigned by default to some
action, you can create a macro to do the action and assign your own key to it.