I am familiar with the ribbon, custom ribbon, callbacks, etc. from working
with the ribbon in Access 2007, but am not that familiar with Excel.

When opening an xls (Excel 2003) workbook using Excel 2007, is there a way
to either hide the ribbon completely or load my own custom ribbon? If so,
how?

Also how can I disable some of the Office Button functions, like I can in
Access?

Thanks for any assisstance.
--

AG
Email: npATadhdataDOTcom

In the ribbon XML, set the StartFromScratch value in the Ribbon setting to
True.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"

<ribbon startFromScratch="false"


--
__________________________________
HTH

Bob

"AG" wrote in message
...
I am familiar with the ribbon, custom ribbon, callbacks, etc. from working
with the ribbon in Access 2007, but am not that familiar with Excel.

When opening an xls (Excel 2003) workbook using Excel 2007, is there a way
to either hide the ribbon completely or load my own custom ribbon? If so,
how?

Also how can I disable some of the Office Button functions, like I can in
Access?

Thanks for any assisstance.
--

AG
Email: npATadhdataDOTcom

"Bob Phillips" wrote in message
...
In the ribbon XML, set the StartFromScratch value in the Ribbon setting to
True.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"

<ribbon startFromScratch="false"


--
__________________________________
HTH

Bob

"AG" wrote in message
...
I am familiar with the ribbon, custom ribbon, callbacks, etc. from working
with the ribbon in Access 2007, but am not that familiar with Excel.

When opening an xls (Excel 2003) workbook using Excel 2007, is there a
way to either hide the ribbon completely or load my own custom ribbon? If
so, how?

Also how can I disable some of the Office Button functions, like I can in
Access?

Thanks for any assisstance.
--

AG
Email: npATadhdataDOTcom







Thanks for the reply Bob.
I am familiar with startfromscratch and creating ribbon xml.

What I am not familiar with is how to load a custom ribbon in Excel.
--

AG
Email: npATadhdataDOTcom

Surely, it is the same as Access? Us the CustomUI editor.

--
__________________________________
HTH

Bob

"AG" wrote in message
...

"Bob Phillips" wrote in message
...
In the ribbon XML, set the StartFromScratch value in the Ribbon setting
to True.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"

<ribbon startFromScratch="false"


--
__________________________________
HTH

Bob

"AG" wrote in message
...
I am familiar with the ribbon, custom ribbon, callbacks, etc. from
working with the ribbon in Access 2007, but am not that familiar with
Excel.

When opening an xls (Excel 2003) workbook using Excel 2007, is there a
way to either hide the ribbon completely or load my own custom ribbon?
If so, how?

Also how can I disable some of the Office Button functions, like I can
in Access?

Thanks for any assisstance.
--

AG
Email: npATadhdataDOTcom







Thanks for the reply Bob.
I am familiar with startfromscratch and creating ribbon xml.

What I am not familiar with is how to load a custom ribbon in Excel.
--

AG
Email: npATadhdataDOTcom

When opening an xls (Excel 2003) workbook using Excel 2007

not possible to have ribbonx in a 2003 workbook but 2003 workbook can open a
excel 2007 add-in when it is running in excel 2007. See especially example
2 he

http://www.rondebruin.nl/compatiblemenu.htm

to hide all of ribbon see code near end this page

http://www.rondebruin.nl/ribbon.htm


"AG" wrote in message
...
|I am familiar with the ribbon, custom ribbon, callbacks, etc. from working
| with the ribbon in Access 2007, but am not that familiar with Excel.
|
| When opening an xls (Excel 2003) workbook using Excel 2007, is there a way
| to either hide the ribbon completely or load my own custom ribbon? If so,
| how?
|
| Also how can I disable some of the Office Button functions, like I can in
| Access?
|
| Thanks for any assisstance.
| --
|
| AG
| Email: npATadhdataDOTcom
|
|
|
|

"Homey" <none wrote in message
...
When opening an xls (Excel 2003) workbook using Excel 2007

not possible to have ribbonx in a 2003 workbook but 2003 workbook can open
a
excel 2007 add-in when it is running in excel 2007. See especially
example
2 he

http://www.rondebruin.nl/compatiblemenu.htm

to hide all of ribbon see code near end this page

http://www.rondebruin.nl/ribbon.htm


"AG" wrote in message
...
|I am familiar with the ribbon, custom ribbon, callbacks, etc. from
working
| with the ribbon in Access 2007, but am not that familiar with Excel.
|
| When opening an xls (Excel 2003) workbook using Excel 2007, is there a
way
| to either hide the ribbon completely or load my own custom ribbon? If
so,
| how?
|
| Also how can I disable some of the Office Button functions, like I can
in
| Access?
|
| Thanks for any assisstance.
| --
|
| AG
| Email: npATadhdataDOTcom
|
|
|
|


Thanks Homey, that worked great. Even removed the Office button, which can't
be done in Access.

Is there any way to load a custom ribbon without using an addin?
In Access there is a loadfromtext method to load a custom ribbon.
I would like to be able to store the xml for my custom ribbon in a hidden
sheet and load it from there.

--

AG
Email: npATadhdataDOTcom

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 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

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
|
|
|