Commandbar Visibility

[Marian]

I have a Word VBA application that displays different commandbars depending
on the template that is currently open. I am now getting an error when using
the visible method for the commandbar. I researched it on the Microsoft
website and they have acknowledged it to be a problem but offer no solution.
Does anyone have a solution?

Thanks!

Marian

 

[JuneTheSecond]

Visible might not be a method but property, so it should be set to true.
Object.Visible=True

 

[Marian]

I am getting the error "Method 'Visible' of object 'CommandBar' failed." The
commandbars are custom, uniquely named, and are set to "visible" depending on
the opened template.

 

[JuneTheSecond]

Could I ask you to which commandbar did you do?
It is written that "this problem occurs if you attempt to hide or show a
Commandbar to which the Visible property does not apply", on Excel error
comments at http://support.microsoft.com/default.aspx?scid=kb;EN-US;166101

 

[JuneTheSecond]

For my joy i made a macro that print out the results of visible property.
Visible is property not method.

Option Explicit

Sub Command_Bars()
Dim ComBar As CommandBar
Dim KeepIt As Boolean
On Error Resume Next
For Each ComBar In Application.CommandBars
KeepIt = ComBar.Visible
Err.Number = 0
ComBar.Visible = True
If Err.Number = 0 Then
Debug.Print ComBar.Name, ComBar.Visible
Else
Debug.Print ComBar.Name, ComBar.Visible, ">>> Visible Property
Failed"
End If
ComBar.Visible = KeepIt
Next ComBar
End Sub