Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help, Seq numbers, Save filename & A button on sheet. | Excel Discussion (Misc queries) | |||
Insert Options button doesn't disappear | Excel Discussion (Misc queries) | |||
Command Button Assignment | Excel Discussion (Misc queries) | |||
Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
How can I create a button to save one worksheet into a new workshe | Excel Discussion (Misc queries) |