Formatting button with preset formats

I have a rolling report where I update issues on a timely basis and what
I do is type the new information in an existing cell full of previous
information and then carefully format the new text so that it is Bold
and 2pts larger in text. This helps to highlight the new items.

Once the report has been faxed I globally format the text to the same
size to await any new text.

Is there a code which I can attach to a button whereby I select the new
text and then press the button so that it formats both bold and size at
the same time please ?

Thanks


TW


---
Message posted from http://www.ExcelForum.com/

Hi TW
Record a Macro doing exactly what you have described.
Bold, 2pts larger, print, reformat to original size.
Once the Macro is done, create a Command Button using your
Forms Toolbar.
Place the Button somewhere on the screen. Right Click on
it to change it's name from Command Button to whatever you
prefer and then right click on it again and assign the
Macro you have created, to it.
Now, whenever you click that button the Macro will run all
of the above commands.

Regards
Michael
-----Original Message-----
I have a rolling report where I update issues on a timely
basis and what
I do is type the new information in an existing cell full
of previous
information and then carefully format the new text so
that it is Bold
and 2pts larger in text. This helps to highlight the new
items.

Once the report has been faxed I globally format the text
to the same
size to await any new text.

Is there a code which I can attach to a button whereby I
select the new
text and then press the button so that it formats both
bold and size at
the same time please ?

Thanks


TW


---
Message posted from http://www.ExcelForum.com/

.