I think you guys have it right. MS does not want you changing the number of
controls that appear in their built-in groups. And no way to enable a
button Excel has disabled. So you've got to have duplicate spellcheck
buttons, Walt.

--
Jim
"Walt" wrote in message
...
| Hi Ron,
|
| So, I think you must have found the same result. Excel's disabling
| of the Spelling control on the Ribbon and Quick Access Toolbar when a
| worksheet is protected cannot be managed.
|
| I was able to load your posted code and it works OK. But when I
| tried to make it look cleaner and substitute visible for enabled in
| <command idMso="Spelling" enabled = "false" /, I saw the error
| message "The 'visible' attribute is not declared". Also, as I
| suspected, the Quick Access Toolbar shows the Spelling button as
| visible but not enabled. Managing the Built-In control would be a
| nicer solution if possible.
|
| I appreciate your thoughts on this Ron.
|
| Best Regards,
| Walt
|
|
| On Feb 19, 12:17 pm, "Ron de Bruin" wrote:
| Not looked very good but I think I go for this (Easy I think)
| And in Macro1 add your unprotect/spelling/protect
|
| 'Callback for customButton1 onAction
| Sub Macro1(control As IRibbonControl)
| ActiveSheet.Unprotect
| Cells.CheckSpelling SpellLang:=1033
| ActiveSheet.Protect
| End Sub
|
| And this is the xml to disable the normal spelling and add a new button
|
| <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
|
| <commands
|
| <!-- Example to disable Spelling--
| <command idMso="Spelling" enabled = "false" /
|
| </commands
|
| <ribbon
| <tabs
|
| <tab idMso="TabReview"
| <group id="customGroup1" label="My Spelling"
insertBeforeMso="GroupProofing"
| <button id="customButton1" label="Spelling" size="large"
onAction="Macro1" imageMso="Spelling" /
| </group
| </tab
|
| </tabs
| </ribbon
| </customUI
|
| --
|
| Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
|