LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Some other program interfering with Excel file (through Excel)

Excel 2003 on WinXP.

I have a workbook that I have distributed to other users; the key elements
(I think) are that there are several worksheets, and when macros are enabled
the default sheet is hidden and a data entry sheet is shown. The data entry
sheet has a commandbutton on it that runs a macro to bring up a userform for
data entry. The sheet itself shows the data, but is protected to prevent
direct data entry.

On one PC, there are two extra toolbars showing in Excel. When this file is
opened on that PC (macros enabled) the data sheet is shown, but the button
ususally never appears, or when it does, clicking once on the sheet itself
makes it disappear.

I've looked in the VBE and there are no other projects at all (no adobe,
nothing but my project), and I looked in the XL start directory and didn't
see anything there either, and there are no add-ins checked (not even the
analysis toolpack).

I'm stuck, because I can't figure out where else these toolbars might be
coming from so I can remove them to see if they are really the cause of the
commandbutton disappearing. I can uncheck them in the view/toolbars menu,
but when closing and re-opening Excel, one of them always reappears, so
something is setting it to be visible every time Excel is opened.

Where else should I be looking?

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
Export .csv file from another program into excel dayoadebayo Excel Discussion (Misc queries) 2 January 17th 07 01:56 PM
is there a way to program my Excel file to do a loop? cfman Excel Discussion (Misc queries) 2 January 11th 07 01:52 PM
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 09:05 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM


All times are GMT +1. The time now is 11:24 PM.

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"