Right now I'm using the following to create shortcuts to
increase/decrease decimals:
Sub increaseDecimal()
Application.CommandBars("formatting").FindControl( ID:=398).Execute
End Sub
Sub decreaseDecimal()
Application.CommandBars("formatting").FindControl( ID:=399).Execute
End Sub
Is there a way to set this up so that a selection of cells will retain
individual cell formats?
For example:
If I have the following selected:
12.935%
$13.4
#,##0.0_)
When I use this macro it will change all of the selected cells to
either a percentage, the dollar, or other custom formats.
Thank you.
--
kbellendir
------------------------------------------------------------------------
kbellendir's Profile:
http://www.excelforum.com/member.php...o&userid=15848
View this thread:
http://www.excelforum.com/showthread...hreadid=273394