shortcut key required...

  • Thread starter Thread starter Anil showreddy
  • Start date Start date
A

Anil showreddy

hi can u give me a shortcut key for

1) To moving a worksheet from one book to another or in the same book
2) To increasing or decreasing fnt size in the cell.

thank you....
 
Enter the following macros:

Sub grow()
For Each r In Selection
r.Font.Size = r.Font.Size + 1
Next
End Sub


Sub shrink()
For Each r In Selection
r.Font.Size = r.Font.Size - 1
Next
End Sub

The assign CNTRL-e to one and CNTRL-f to the other.


CNTRL-e and CNTRL-f will increase/decrease the font size of the selected
cells.
 
Mr. gary,

its excellent.... thankyou ...

can you give me for another one also....?
 
Back
Top