ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RibbonX: Problem with OnLoad (https://www.excelbanter.com/excel-programming/403330-ribbonx-problem-onload.html)

[email protected]

RibbonX: Problem with OnLoad
 
I have been trying to use OnLoad in an existing application without
success. Could someone take a look at this code and tell me what I am
doing incorrectly?

This code works:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?
<customUI onLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
2006/01/customui"

<!-- Add Custom group to the Home tab in the ribbon--
<!-- The example add a dynamic menu control--

<ribbon
<tabs
<tab idMso="TabHome"
<group id="customGroup1" label="My Menu"
insertBeforeMso="GroupEditing"


</group
</tab

</tabs
</ribbon
</customUI

This code which I am trying to use generates an error:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?
<customUI OnLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
2006/01/customui"

<!-- Add Custom group to the Home tab in the ribbon--
<!-- The example add a dynamic menu control--

<ribbon
<tabs
<tab id="TabMyTools" label="MyTools" insertAfterMso="TabView"

</tab
</tabs
</ribbon
</customUI

The error indicates that OnLoad is not defined in the DTD/Schema.
Both workbooks have only a simple OnLoad sub in them.

Thanks for your help.
bob

Ron de Bruin

RibbonX: Problem with OnLoad
 
Must go now but I use it on this page.

look at the code
http://www.rondebruin.nl/dynamic.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
I have been trying to use OnLoad in an existing application without
success. Could someone take a look at this code and tell me what I am
doing incorrectly?

This code works:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?
<customUI onLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
2006/01/customui"

<!-- Add Custom group to the Home tab in the ribbon--
<!-- The example add a dynamic menu control--

<ribbon
<tabs
<tab idMso="TabHome"
<group id="customGroup1" label="My Menu"
insertBeforeMso="GroupEditing"


</group
</tab

</tabs
</ribbon
</customUI

This code which I am trying to use generates an error:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?
<customUI OnLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
2006/01/customui"

<!-- Add Custom group to the Home tab in the ribbon--
<!-- The example add a dynamic menu control--

<ribbon
<tabs
<tab id="TabMyTools" label="MyTools" insertAfterMso="TabView"

</tab
</tabs
</ribbon
</customUI

The error indicates that OnLoad is not defined in the DTD/Schema.
Both workbooks have only a simple OnLoad sub in them.

Thanks for your help.
bob


Jim Rech[_2_]

RibbonX: Problem with OnLoad
 
OnLoad="OnLoad"

XML is case sensitive. So this must be:

onLoad="OnLoad"

--
Jim
wrote in message
...
|I have been trying to use OnLoad in an existing application without
| success. Could someone take a look at this code and tell me what I am
| doing incorrectly?
|
| This code works:
| <?xml version="1.0" encoding="UTF-8" standalone="yes"?
| <customUI onLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
| 2006/01/customui"
|
| <!-- Add Custom group to the Home tab in the ribbon--
| <!-- The example add a dynamic menu control--
|
| <ribbon
| <tabs
| <tab idMso="TabHome"
| <group id="customGroup1" label="My Menu"
| insertBeforeMso="GroupEditing"
|
|
| </group
| </tab
|
| </tabs
| </ribbon
| </customUI
|
| This code which I am trying to use generates an error:
| <?xml version="1.0" encoding="UTF-8" standalone="yes"?
| <customUI OnLoad="OnLoad" xmlns="http://schemas.microsoft.com/office/
| 2006/01/customui"
|
| <!-- Add Custom group to the Home tab in the ribbon--
| <!-- The example add a dynamic menu control--
|
| <ribbon
| <tabs
| <tab id="TabMyTools" label="MyTools" insertAfterMso="TabView"
|
| </tab
| </tabs
| </ribbon
| </customUI
|
| The error indicates that OnLoad is not defined in the DTD/Schema.
| Both workbooks have only a simple OnLoad sub in them.
|
| Thanks for your help.
| bob




All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com