Can You Have A Font's Properties Change When You Click The Cell?

  • Thread starter Thread starter AM I Am
  • Start date Start date
A

AM I Am

First and foremost, I've just spent some time reading the posts in this ng and
have learned more than a few tricks, that as a novice, I would've never been
able to complete. With that in mind a big thanks goes out to the many
contributors here.

That being said, here is what I'm trying to accomplish:

In a cell, I've got the letter 'A', and it's color is grey. When I click on it,
I'd like it to become black and bold. Is there any way to accomplish this? Also,
if I were to click the cell again, it would return to it's original state.

I suppose I would not be adverse to a check box that had the letter instead of
the check mark either....

Thanks.

AM
 
AM,

A Selection_Change event macro can be written to do this. It must examine
and save the current formatting, so that it can restore it when the cell is
left for another, or must set it back to a standard format, if the sheet has
only one format for the cells. We can write you one if you're willing to go
into macros.
 
AM,

A Selection_Change event macro can be written to do this. It must examine
and save the current formatting, so that it can restore it when the cell is
left for another, or must set it back to a standard format, if the sheet has
only one format for the cells. We can write you one if you're willing to go
into macros.
Click to expand...

Earl,

On the macros, I'd be fine with it except my Excel 2003 gives me a banner about
macros and security levels and optional procurement of certificates etc. so I'm
not sure this is how I want to go and may have to pick an alternative.

As for writing it, please forgive the lack of knowledge in the etiquette dept.
but would it be okay to say yes even if in the end I don't use it? At the very
least it would give me some badly needed exposure to some of this coding that I
do not know and is holding me back.

Thanks again for the timely response.

AM
 
Back
Top