Toolbar

  • Thread starter Thread starter Milandra
  • Start date Start date
M

Milandra

Is there anyway that we can create our own toolbars to
open each different forms we want(shorcut) and shut down
regular toolbar.

Thanks in advance,
Milandra
 
Milandra,
Here's some code that might be helpful. Create a toolbar and have its name
start with "WSU" (or alter the code to fit what you do name it).

*** code start ***
'Remove all commandbars that don't start with "WSU"
For Each itm In Application.CommandBars
If itm.Type = 0 Or itm.Type = 1 Then
itm.Visible = Left(itm.Name, 3) = "WSU"
End If
Next
*** code end ***

Thanks,
Mattias Jonsson
 
Jonsson,
Could you please guide me a simple way to create toolbar.
I want it to look the same way as regular toolbar
attatched to the Menubar that I created.

Thanks,
Milandra
 
Milandra,
Jeff's post has got more detail on how to actually create the toolbar and
having it do something useful. My post was geared towards hiding the Access
built-in toolbars and displaying your toolbar(s) once you have it/them set
up.

Thanks,
Mattias Jonsson
 
Back
Top