Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Toolbar Customize Dialog Box
Hi everybody, I am creating an application in Excel 2000 and I have created two custom command bars. I dont want users to be able to change the command bars so I have eliminated all access to the Customize Dialog Box except one. When you double click the left mouse button on the command bar the...- ABH29
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2000 VBA - creating new Command Bar
Hi, I am trying to create a new Command Bar object using VBA in Excel 2000. I use the following line of code: Set myToolBar = CommandBars.Add("Custom",msoBarTop) When I run the code I get a runtime 5 - invalid procedure call or argument error. Would appreciate any help that anyone...- ABH29
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
