shortcut key required...
 

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....
--
Anil showreddy

shortcut key required...
 

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.
--
Gary''s Student - gsnu200770


"Anil showreddy" wrote:

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....
--
Anil showreddy

shortcut key required...
 

Mr. gary,

its excellent.... thankyou ...

can you give me for another one also....?
--
Anil showreddy


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200770


"Anil showreddy" wrote:

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....
--
Anil showreddy