Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a built-in toolbar permanently not visible
When you instantiate application level events, you create a global variable.
When an error occurs while debugging I assume you hit the reset button which clears that variable. -- Regards, Tom Ogilvy "R Avery" wrote in message ... I have my toolbars set up the way I like them, and the Reviewing toolbar is not part of them. HoweWhever, 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a built-in toolbar permanently not visible
I see. I have tried setting the global variable to nothing and then
setting it back to Application, the events still don't fire. In fact, even if i unload and reload the add-in that traps these events, it still can't trap them. Tom Ogilvy wrote: When you instantiate application level events, you create a global variable. When an error occurs while debugging I assume you hit the reset button which clears that variable. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanently delete toolbar | Excel Discussion (Misc queries) | |||
Can't set visible page breaks permanently | Excel Discussion (Misc queries) | |||
Permanently Changing a Toolbar | Excel Discussion (Misc queries) | |||
Permanently visible colunm in an Excel chart | Excel Discussion (Misc queries) | |||
How to make the drop down for comboBox visible in toolbar | Excel Programming |