toolbar

[Guest]

when I create a custom toolbar in excel, it disappears after I reboot (not
every time). How can I get the custom toolbar to come up after each time I
reboot? Also, some toolbars have now started to pop up automatically (ie.
the "review" toolbar). How can I get that to stop?

 

[Jim Rech]

If you manually create a custom toolbar and close Excel, it should be there
when you next start Excel. Excel saves your current toobar configuration in
an file every time you exit (something like Excel.xlb depending on your
excel version). If you're not seeing this I don't know why not. Of course
if you delete the XLB file all customizations are lost (which is good to
know if you mess things up).

As to the reviewing toolbar here's some info from a previous post:

---
The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review". There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

You can kill the added file properties manually or run the below macro to do
it. This macro is in my Personal and attached to a toolbar button for easy
access.

If the toolbar pops up every time you start Excel then perhaps there is a
workbook in your XLSTART folder that is the cause.

--
Jim Rech
Excel MVP

Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentProperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = "_" Then _
x.Item(Counter).Delete
Next
CommandBars("Reviewing").Visible = False
End Sub