LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 220
Default Make a built-in toolbar permanently not visible

I have my toolbars set up the way I like them, and the Reviewing toolbar
is not part of them. However, often when I open up excel files from
other people, the Reviewing toolbar pops up. I had created an addin
with an application event trapper that would trap the OnWorkbookOpen
event and make the reviewing toolbar.visible=false. This works, but
there is a problem with it; whenever I am debugging something and it
breaks, the add-in is no longer able to trap the application level
events. I do not know why, so I cannot fix it.

Is there any other way to ensure that a toolbar never popups? If no one
can think of a way, I will probably end up writing a VB6 dll to do it -
they do not suddenly break because i am debugging in VBA. Any help
would be appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
permanently delete toolbar rrChuck Excel Discussion (Misc queries) 2 October 28th 09 01:44 PM
Can't set visible page breaks permanently Robert Baughman Excel Discussion (Misc queries) 0 June 24th 09 07:05 PM
Permanently Changing a Toolbar Mark P[_2_] Excel Discussion (Misc queries) 7 January 23rd 09 12:58 AM
Permanently visible colunm in an Excel chart Robin McInnes Excel Discussion (Misc queries) 4 April 5th 05 08:45 AM
How to make the drop down for comboBox visible in toolbar Taher Baderkhan Excel Programming 0 August 20th 03 02:53 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"