Menu

Trouble removing toolbar - why won't my code work?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Simon Lloyd[_895_] Simon Lloyd[_895_] is offline

Simon Lloyd[_895_] is offline

external usenet poster

Posts: 1

Default

Trouble removing toolbar - why won't my code work?

;6973922 Wrote:
I have the code below in an add-in that I have created. The toolbar I
am trying to close is from a third-party add-in that I use and I
cannot
get into their code. When I close the toolbar and re-open excel the
toolbar comes up again. If I run the code after excel is open then the
code works fine so this add-in must be the last to run. Is there a
way
to run my add-in after all other add-ins are run? I think that would
solve the problem.

Private Sub Workbook_Open()
Application.CommandBars("Custom Toolbar").Visible = False
End Sub

Thanks

I'm not sure about your request as i am no expert, but in my experience
you cannot turn a command bar or menu bar off until you have turned one
on first, so perhaps turn the worksheet menu bar back on then turn of
the custom bar.

Hope this helps,
Regards,
Simon

--
Simon Lloyd

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trouble Removing a value from a ListBox	trward79	Excel Programming	1	October 11th 06 08:30 PM
Trouble getting new toolbar buttons to work properly in Excel 2003	Dave in Nashville	Excel Worksheet Functions	1	June 22nd 06 05:41 AM
removing acontrol from the toolbar	joe	Excel Programming	4	February 21st 06 05:48 PM
removing a toolbar with code	Papa Jonah	Excel Programming	4	February 22nd 05 07:49 PM
trouble removing rows	Spork Rhonewood[_4_]	Excel Programming	1	June 23rd 04 04:46 PM

All times are GMT +1. The time now is 02:23 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement