Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset ToolBox
I Accidentally deleted all items in my VBE Userform's ToolBox.
How can I restore it to it's initial state? I unsuccessfully deleted Excel.xlb, to no avail. Thanks, -- AP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset ToolBox
Saved from a previous post:
I had a similar problem a little while ago. The toolbox would appear, but all the icons were missing. I got this message from Rob Bovey: With Excel shut down, search your hard disk(s) for a file called Excel.box (it's the VBE toolbox equivalent of an Excel .xlb file). Delete it and then restart Excel. That may do the trick. And this message from Tom Ogilvy: It appears to be just a special multipage control. If you right click above the tabs, you get a shortcut menu that allows you to add and delete pages. If you right click on one of the tabs, you get the additional controls popup menu. Select that and just click the controls you want on the tab/page. I believe I did a little of Tom's suggestion, until I broke down and just did them all at once with Rob's suggestion. (It scared the heck out of me!) ======= You may want to rename excel.box to excel.boxOLD--just in case this doesn't help and you want to get it back. Ardus Petus wrote: I Accidentally deleted all items in my VBE Userform's ToolBox. How can I restore it to it's initial state? I unsuccessfully deleted Excel.xlb, to no avail. Thanks, -- AP -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset ToolBox
Thanks! Worked like a treat...
Cheers, -- AP "Dave Peterson" a écrit dans le message de ... Saved from a previous post: I had a similar problem a little while ago. The toolbox would appear, but all the icons were missing. I got this message from Rob Bovey: With Excel shut down, search your hard disk(s) for a file called Excel.box (it's the VBE toolbox equivalent of an Excel .xlb file). Delete it and then restart Excel. That may do the trick. And this message from Tom Ogilvy: It appears to be just a special multipage control. If you right click above the tabs, you get a shortcut menu that allows you to add and delete pages. If you right click on one of the tabs, you get the additional controls popup menu. Select that and just click the controls you want on the tab/page. I believe I did a little of Tom's suggestion, until I broke down and just did them all at once with Rob's suggestion. (It scared the heck out of me!) ======= You may want to rename excel.box to excel.boxOLD--just in case this doesn't help and you want to get it back. Ardus Petus wrote: I Accidentally deleted all items in my VBE Userform's ToolBox. How can I restore it to it's initial state? I unsuccessfully deleted Excel.xlb, to no avail. Thanks, -- AP -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I GIVE A CONTROL TOOLBOX CHECKBOX A VALUE IN EXCEL? | Excel Worksheet Functions | |||
Establish Default Titles For Drop Windows And Reset Button | New Users to Excel | |||
Autofilter reset button | Excel Discussion (Misc queries) | |||
Reset Button in Excel? | Excel Worksheet Functions | |||
Toolbox Problem. | Excel Discussion (Misc queries) |