View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 2007 Ribbon control disabled by Excel when sheet is protected - Override with getEnabled?

Hi Walt

You can hide the group

<tab idMso="TabReview"
<group idMso="GroupProofing" visible="false"/
</tab

And make a new one with the same buttons and your own spelling button
Nicer then two spelling buttons

But if the use have it in the QAT you still have the problem that the user can't use that option


--

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


"Walt" wrote in message ...
Hi Ron & Jim,

I may not like the answer, but I understand and I thank you both for
the consideration.

An instance where I've enabled and intercepted the spell checker in
the past has been:

Sub UnlockedSpellCK() 'PROTECTED SHEET UNLOCKED CELLS SPELL CHECKER
Dim TstRng As Range, CL As Range
On Error GoTo UnlockedSpellCKERROR
With ActiveSheet
Set TstRng = .Range("AB1") 'ANY KNOWN EMPTY CELL JUST TO
GET STARTED
For Each CL In .UsedRange.Cells
If CL.Locked = False Then Set TstRng =
Application.Union(TstRng, CL)
Next
.Unprotect
TstRng.CheckSpelling
.Protect DrawingObjects:=False, Contents:=True,
Scenarios:=True
End With
Set TstRng = Nothing: Set CL = Nothing
Exit Sub
UnlockedSpellCKERROR:
Set TstRng = Nothing: Set CL = Nothing
ActiveSheet.Protect DrawingObjects:=False, Contents:=True,
Scenarios:=True
MsgBox "Error in 'UnlockedSpellCK' routine."
End Sub

In it, I only spell check the UnLocked cells that the user has access
to change. An even nicer solution would be if Excel, by default,
didn't completely disable the spell checker when a protected sheet is
active, but would just check any UnLocked cells.

Best Regards,
Walt

On Feb 20, 7:45�am, "Jim Rech" wrote:
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