LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Code that keeps creating a toolbar - where might that code be hidden?

Many thanks to all for your suggestions. I'll try to schedule access to that
machine and see if I can figure it out. The only bad news is that IT has
locked the registry, so if the other solutions aren't sufficient, I'll have
to deal with some red tape 8-/

Thank you!
Keith

"Simon Murphy" wrote in message
...
Keith
It could be an xll add-in - try searching for *.xll on your local drive
for anything you recognise
or it could be an xla - try a similar serach
Or it could be a COM add-in
of which they are 2 types
user specific - right click in the menu area, then on the commands tab of
the customize box click tool, look down the left to COM Add-ins and drag
that button into a toolbar somewhere. Then click it and see if there are
any add-ins listed, if not, read on
Machine specific COM add-ins can only be checked for directly in the
registry see here for where/how (item 7):
http://www.cpearson.com/excel/StartupErrors.htm

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training

"Keith" wrote in message
...
We have a vendor-provided corporate application that is integrated into
our Offce 2003 suite (database queries behind the scenes, etc.). The part
of the application that I see is a toolbar in Excel (all machines are
WinXP). Unfortunately, their program is poorly written, and does things
like hide commandbuttons in other workbooks, etc.

When I go into Excel View/Toolbars and click to suppress viewing the
toolbar, it goes away...but the next time Excel is opened, the toolbar
comes back (is automatically visible again). Of course, the presence of
the toolbar itself isn't likely to cause the commandbuttons in other
workbooks to dissapear, but I figure if I can find the code that is
auto-showing the toolbar, I might find the rest of the code as well.

I didn't find any add-ins, nor any files in any startup folders (at least
anywhere I could think of).

So, if you wanted to tick off your customers by figuring out a way to
make a toolbar visible every time Excel starts, how would you do it? I'm
asking because I want to use your ideas to work backwards and figure out
where their code is, so I can figure out a workaround. It is possible
that they might be using some .NET code somewhere that puts the toolbar
back anytime Excel opens, but I wouldn't even know where to look for
something like that if the code isn't in Excel itself. There might also
be other directories where some sort of very hidden add-in might be
located that I don't know about, so any ideas would be greatly
appreciated.

Many thanks,
Keith







 
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
code failing in hidden rows RobN[_2_] Excel Discussion (Misc queries) 16 January 16th 08 02:19 AM
Formula or Code to keep Hidden Rows Hidden Carol Excel Worksheet Functions 6 May 1st 07 11:45 PM
Code to access a hidden worksheet sir Lancelot Excel Programming 3 November 19th 05 03:15 PM
Code for Printing Hidden Sheets Todd[_7_] Excel Programming 2 December 3rd 03 02:12 PM


All times are GMT +1. The time now is 09:02 AM.

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

About Us

"It's about Microsoft Excel"