losing a toolbar

S

shank

I'm trying to setup my default workbook/sheet. Everything is working so far,
except I cannot get rid of the standard toolbar. It keeps coming back. I do
I get it out of my default preferences?
thanks!
 
M

Mark Rosenkrantz

Hi there;

Right click on any toolbar and unchech the checkbox for the toolbar you
don't want to see anymore.
Save the file, close Excel and the next time you start it, it must not be
visible anymore.

Mark.

More Excel ? www.rosenkrantz.nl or [email protected]
 
S

shank

Nope! Does not work. Here's what I do...
1) setup the workbook as I like
2) right-click and uncheck that toolbar and all other I do not like. That
leaves me with my custom toolbar I made.
3) opt to 'Save As...' a template
4) navigate to \programfiles\microsoft office\office 10\xlstart
5) save my file as book.xlt
6) close excel and re-open excel
7) standard toolbar is back again!!! Arghh....

What am I doing wrong?
thanks!
 
D

Dave Peterson

How about just Tools|customize|toolbars tab
and uncheck the Standard toolbar

close excel and reopen.

These toolbar settings aren't saved in your book.xlt file. They're saved in a
file with an extension of .xlb. (the name and location vary with versions of
excel and windows.)

If you tried that and it doesn't work, then it sounds like your settings aren't
being stored when you leave excel. (I think that there have been a few posts
that complain about Windows permissions being set to stop users from doing
this. Mostly by IT folks for users on networks. But I think windows XP users
can suffer the same "feature".

If that's the case, maybe you could just create a small workbook with a single
macro and store it in your XLStart folder.

All it'll do is open, close that toolbar and then close itself.

I would use this as a temporary workaround until I could find out the real
cause:

Option Explicit
Sub auto_open()

On Error Resume Next
Application.CommandBars("standard").Visible = False
On Error GoTo 0

ThisWorkbook.Close savechanges:=False

End Sub


(Save your work before testing. It closes itself without saving--even while
testing!)
 
S

shank

I tried your suggestion for unchecking and that did not work either. I also
searched my hardrive for *.xlb and found nothing. I appreciate the
suggestion for the macros, but then I'd have to go through another message
box asking me if I wanted macros enabled when I open the file. I guess I
will right-click and uncheck it each time, until I get a solution.

I'm an admin on a non-network WinXP Pro, w/Office XP Pro, and of course, all
the service packs.

thanks
 
D

Dave Peterson

I put that workbook in my XLStart folder and wasn't prompted about macros. You
may want to try it.

And if you search for *.xlb again, make sure you look for hidden files and
through hidden folders.

Some versions of windows (xp?) have this setting toggled so it won't find
anything.

And to make sure you really have one,
pen excel
tools|customize|toolbars tab|new
(just to create a dummy *.xlb)

Then search again.
 
D

David McRitchie

Hi Shank,
Most people using macros have a
personal.xls workbook which they probably have
residing in the XLSTART folder so that it comes up
immediately when Excel opens.

Your toolbars reside in an .XLB file..

Usually you can make the changes wherever you are at,
but if you are having problems. Close all of the workbooks
except for your personal.xls which you want to unhide,
make the changes to your toolbars, then hide the file again
(Window (menu), hide/unhide) so that macros are available
to other open workbooks. .

additional reading in
http://www.mvps.org/dmcritchie/excel/toolbars.htm
 
S

shank

I went to the Knowledge Base and found that the XLB file was under
\documents and settings\...
I can't believe my search wouldn't find it. Anyway....

The issue was that no matter what I did, Excel refuses to lose the Standard
toolbar. In the Excel help section, it lays out a renaming sceme for
Excel10.xlb to save my new toolbar settings. Whenever I closed excel, it
would generate a new excel10.xlb file... EXCEPT when I removed the Standard
toolbar like I wanted, it would flat refuse to generate a new excel10.xlb
file, which left me back at square one.

So, because excel refuses to lose the Standard toolbar, I decided to use
that toolbar for my own personal bar. I'm not happy about it, but it will
get me the buttons I wanted.

thanks all...!!!
 
Top