I see your point. I'll have to think more on that one. Thank you for
looking into it also.

On Wed, 07 Jul 2004 07:53:33 -0700, keepITcool
wrote:

Tonto..

problem is.. as soon as your are in Edit Mode you cant run macro's..

i've already tried to subclass the buttons... no go :(
i've already tried if it would work from menuitem iso button.. no go:(

i'll do some research... maybe you rephrase and start a new thread?
"How to exec a commandbar button while in edit mode"


see if i can hack into this..
(or add a page to the insert symbol dialog...

or maybe it's all very simple and we're just missing the obvious...

<grin... hmmmm


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Tonto wrote:

Thanks. I changed it slightly like below to more efficiently account
for the small Greek letters, which I added. I also changed to module
reference to basGreek instead of Module1, so that I can put it in its
owm module in the Personal Macro Workbook.

This is a great start. However, what the DoGreek sub does is to
change the value of the active cell to the selected Greek letter.
What I want to do is to emulate the functionality of the
= + - * / ^ ( ) : , % $
optional buttons which a user can place on a toolbar using
Tools|Customize|Commands. These buttons, clicked when actively
editing a cell, will insert the appropriate character into the cell at
the point of the cursor. I am hoping somebody can tell me what
commands these buttons invoke so that I can apply a modified version
to your code. It is excellent, thank you.



Sub DoGreek()

ActiveCell.Value = Application.CommandBars.ActionControl.Parameter
ActiveCell.Font.Name = "Courier New"

End Sub