Save assigned button
 

I took quite a bit of time to assign macros to buttons on my toolbar
(specifically, made sure visual basic tool bar was open and added them
there), but when I exited the document and reopened it, the buttons are now
gone.

Am I missing a step or set up?

Thanks,
DeDe Pullen

Save assigned button
 

Are objects hidden? Go to Tools--Options--View and see if Show All is
selected. If not, select it.
--
Brevity is the soul of wit.


"Deedles" wrote:

I took quite a bit of time to assign macros to buttons on my toolbar
(specifically, made sure visual basic tool bar was open and added them
there), but when I exited the document and reopened it, the buttons are now
gone.

Am I missing a step or set up?

Thanks,
DeDe Pullen

Save assigned button
 

DeDe

Menu and Toolbar customizations are stored in your Excel"x".xlb file

"x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003.

If it gets too large, it can become unstable.

Or perhaps if on a network, Excel is confused about where to store it.

Do a search for this file. There could be more than one *.xlb file so may have
to check all copies to see which is loading.

Usually stored in..................

C:\Documents and Settings\username\Application Data\Microsoft\Excel

When found, first rename the *.XLB file to *.OLD file. Note the size of this
file in kb.

Now close out Excel then re-open.

Make a few minor changes to a menu or toolbar then close Excel.

Does Excel create a new *.XLB file?

Is it basically the same size as the *.OLD file?

Reopen Excel. Have your changes stuck?

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Wed, 6 Sep 2006 09:20:02 -0700, Deedles
wrote:

I took quite a bit of time to assign macros to buttons on my toolbar
(specifically, made sure visual basic tool bar was open and added them
there), but when I exited the document and reopened it, the buttons are now
gone.

Am I missing a step or set up?

Thanks,
DeDe Pullen

Gord Dibben MS Excel MVP