Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...

I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
--
Brevity is the soul of wit.


"Denise" wrote:

Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...

You've obviously not been stuck with MS's new way to format text numbers -
lucky you! You can't just format them anymore. If it were that simple. I'd
still have hair. :o)

"Dave F" wrote:

I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
--
Brevity is the soul of wit.


"Denise" wrote:

Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...

Are you talking about XL 2007? Why not just right-click the cells and select
format that way?
--
Brevity is the soul of wit.


"Denise" wrote:

You've obviously not been stuck with MS's new way to format text numbers -
lucky you! You can't just format them anymore. If it were that simple. I'd
still have hair. :o)

"Dave F" wrote:

I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
--
Brevity is the soul of wit.


"Denise" wrote:

Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...

Well, I don't know if they will let me do it again in 2007 but not in 2003.

And I'm sure the non-profit I work for isn't going to run out and buy it
just because some programmer at MS didn't think this through.

Now, if you want to buy Office 2007 for us with a volume license, I'm sure
your donation to IOCC in Baltimore would be tax-deductible as well as greatly
appreciated. :o)

"Dave F" wrote:

Are you talking about XL 2007? Why not just right-click the cells and select
format that way?
--
Brevity is the soul of wit.


"Denise" wrote:

You've obviously not been stuck with MS's new way to format text numbers -
lucky you! You can't just format them anymore. If it were that simple. I'd
still have hair. :o)

"Dave F" wrote:

I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
--
Brevity is the soul of wit.


"Denise" wrote:

Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...