HIDE ITEM PROTECTION IN TOOLBAR

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
I wonder if there is a possibility to hide the item protection in the toolbar,by opening workbook?
Any idea?
Thanks
 
OK

Thanks for the answer. I'll brows the link you left.

Yours in EXCELent Frustration

KniteMare

If it was eazy everyone would be doing it.
 
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi,

The use of ID-numbers for controls override heavy problem when working with different language-versions :)

The method FindControls is depended on ID-numbers.

Following code shows how to list ID-numbers.
(It´s swedish inspired but hopefully You see what You can do.)

<pre>
Sub Lista_Alla_Verktygsfält_Kontrollers_NamnIDnr()
Dim cbVFalt As CommandBar
Dim cbKontroll As CommandBarControl
Dim RnCell As Range

With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With


On Error Resume Next

With ActiveWorkbook
.Worksheets("Menynamn och ID-nummer").Delete
.Worksheets.Add
End With

ActiveSheet.Name = "Menynamn och ID-nummer"

Set RnCell = Range("A1")

For Each cbVFalt In Application.CommandBars
With RnCell
.Font.Bold = True
.Value = cbVFalt.NameLocal & " " & "ID-nr:" & cbVFalt.Index
End With
For Each cbKontroll In cbVFalt.Controls
Lista_Kontroller RnCell, cbKontroll
Next cbKontroll
Next cbVFalt
Columns("A:B").EntireColumn.AutoFit

With Application
.ScreenUpdating = True
.DisplayAlerts = True
End With

End Sub

Sub Lista_Kontroller(rnMal As Range, cbKontroll As CommandBarControl)
Dim cbKontroller As CommandBarControl
On Error GoTo Felhantering:

Set rnMal = rnMal(2, 1)

rnMal.Value = cbKontroll.Caption
rnMal(1, 2).Value = cbKontroll.ID

For Each cbKontroller In cbKontroll.Controls
Lista_Kontroller rnMal, cbKontroller
Next cbKontroller

Felhantering:
End Sub
</pre>

Kins regards,
Dennis
 
Upvote 0
Dennis,

OK, I see what this is doing. I'll give it an american-english language translation for the variable and sheet names and run it here.

Thanks

Yours in EXCELent Frustration

KniteMare

In my mind I am already on Vacation, with an option to retire.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top