Greyed out toolbar buttons

[AcousticalConsultant]

Here's another question regarding toolbars:

Is there any way of greying out custom toolbar buttons? Like for example when there are no documents opened, the "save" button is shaded out. If it's possible, where do I define my condition?

Thanks in advance!

 

[JoaoTL]

Hi, hit Rigth Button over the Access ToolBar, chose customize and NEW, insert toolbar name then chose propreties and customize you toolbar.

Best Regards

---
JoaoTL
mail@jtl.co.pt
MS Access Site:

http://www.jtl.co.pt

The Page:

http://www.jtl.co.pt/Access

moved to

http://www.jtl.co.pt

 

[AcousticalConsultant]

JoaoTL,

Well that's not really what I was looking for. I know how to create and customize the toolbar, but I wanted the buttons on the toolbar to be shaded out when certain conditions were true (I wanted them to be active only when a specific document was opened).

So I used this:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
Application.CommandBars("myBar&quot.Controls(1).Enabled = False
End Sub

To disable the button when I close the document, and then:

Private Sub Workbook_Open()
Application.Commandbars("myBar&quot.Controls(1).Enabled = True
End Sub

To re-enable the button when the document has been opened.

Thanks anyway!
Have a good one.

 

[JoaoTL]

Ok, i will post a function soon, but i think this is a similar question see thread: thread707-154059 Best Regards

---
JoaoTL
mail@jtl.co.pt
MS Access Site:

http://www.jtl.co.pt

The Page:

http://www.jtl.co.pt/Access

moved to

http://www.jtl.co.pt