Thanks Homey, but I don't think client will accept either.
Is it possible to run code (macro) when user double clicks or presses Enter
on a particular cell?
If so, can you point me to an example?

--

AG
Email: npATadhdataDOTcom


"Homey" <none wrote in message
...
you can add buttons to sheet but no possble to pres Tab to put focus on a
button. users have to click button. so it seem you connot have exactly
what
you want. so pick best of-

-Do 2 versions, one for xl2003 (xls) and one for xl2007 (xlsm).
-Do one version (xls) but have it open XLAM when use in xl2007 (exampl 2
on
Ron site)
-Have one version (xls) and (if it have menu) tell users to find this menu
on xl2007 Add-ins tab.
-Use buttons which users muct click

that all i can think of.


"AG" wrote in message
...
|
| "Tim Li - MSFT" wrote in message
| ...
| Hello AG,
|
| If you only work with a Excel 2003 Workbook we'll not be able to
customize
| the Ribbon in Excel 2007 except we use an COM add-in.
|
| To your scenario I have two suggestions, however, both of them are
| workarounds:
|
| 1st, to save your Excel 2003 Workbook as Excel 2007 format, because
Excel
| 2007 Workbook formats are actually zipped XML, and we could easily
build
a
| customized Ribbon by using a tool named "CustomUIEditor", you can
refer
to
| these links for the detailed steps:
|
| Extend The 2007 Office System With Your Own Ribbon Tabs And Controls
| http://msdn.microsoft.com/en-us/magazine/cc163469.aspx
|
| Custom UI Editor Tool
| http://openxmldeveloper.org/articles...muieditor.aspx
|
| Second option is, as you know , to build a COM add-in. You could get
| started from he
|
| Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
| http://msdn.microsoft.com/en-us/library/aa338202.aspx
|
|
| Best regards,
| Tim Li
| Microsoft Online Community Support
|
| Delighting our customers is our #1 priority. We welcome your comments
and
| suggestions about how we can improve the support we provide to you.
Please
| feel free to let my manager know what you think of the level of
service
| provided. You can send feedback directly to my manager at:
| .
|
|
| Tim,
|
| Thanks for the reply.
| My client will be distributing the workbook to his customers and it must
| remain in 2003 format with no add-ins required.
| Also, the workbook will be used with a screen reader.
| Hiding the ribbon completely will be ok, if I can find some way to
provide
a
| couple of additional menu-like functions.
| A simple row of buttons would be fine, but I haven't found a method of
| setting focus to a command button.
| Basically, anything that a user could tab to and press enter to activate
a
| function would work.
|
| Any suggestions?
|
| --
|
| AG
| Email: npATadhdataDOTcom
|
|
|