| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lost toolbar
I moved a toolbar off the screen and now can not find it.
In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost toolbar
So you know the name of the toolbar???
If yes, try this: Hit alt-f11 to get to the VBE. Hit ctrl-g to see the immediate window type this and hit enter: Application.CommandBars("YourToolbarNameHere").Pos ition = msoBarBottom Change the name to what you need. Then back to excel and look at the bottom of the screen and move it where you want. Pat wrote: I moved a toolbar off the screen and now can not find it. In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost toolbar
I'm looking for the Pivot Table Toolbar - Is that the name to use
or how can I find the correct name? Thanks Pat "Dave Peterson" wrote: So you know the name of the toolbar??? If yes, try this: Hit alt-f11 to get to the VBE. Hit ctrl-g to see the immediate window type this and hit enter: Application.CommandBars("YourToolbarNameHere").Pos ition = msoBarBottom Change the name to what you need. Then back to excel and look at the bottom of the screen and move it where you want. Pat wrote: I moved a toolbar off the screen and now can not find it. In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost toolbar
I use xl2003 and if I'm looking at a worksheet that contains a pivottable, I can
click on the pivottable and choose: Show pivottable toolbar Or I can click on View|Toolbars|Pivottable. ========= If that doesn't work, try two commands in the immediate window of the VBE: application.CommandBars("Pivottable").visible = true and then application.CommandBars("Pivottable").Position = msoBarBottom Pat wrote: I'm looking for the Pivot Table Toolbar - Is that the name to use or how can I find the correct name? Thanks Pat "Dave Peterson" wrote: So you know the name of the toolbar??? If yes, try this: Hit alt-f11 to get to the VBE. Hit ctrl-g to see the immediate window type this and hit enter: Application.CommandBars("YourToolbarNameHere").Pos ition = msoBarBottom Change the name to what you need. Then back to excel and look at the bottom of the screen and move it where you want. Pat wrote: I moved a toolbar off the screen and now can not find it. In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost toolbar
Thank you ... that worked
"Dave Peterson" wrote: I use xl2003 and if I'm looking at a worksheet that contains a pivottable, I can click on the pivottable and choose: Show pivottable toolbar Or I can click on View|Toolbars|Pivottable. ========= If that doesn't work, try two commands in the immediate window of the VBE: application.CommandBars("Pivottable").visible = true and then application.CommandBars("Pivottable").Position = msoBarBottom Pat wrote: I'm looking for the Pivot Table Toolbar - Is that the name to use or how can I find the correct name? Thanks Pat "Dave Peterson" wrote: So you know the name of the toolbar??? If yes, try this: Hit alt-f11 to get to the VBE. Hit ctrl-g to see the immediate window type this and hit enter: Application.CommandBars("YourToolbarNameHere").Pos ition = msoBarBottom Change the name to what you need. Then back to excel and look at the bottom of the screen and move it where you want. Pat wrote: I moved a toolbar off the screen and now can not find it. In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost toolbar
Which suggestion?
Pat wrote: Thank you ... that worked "Dave Peterson" wrote: I use xl2003 and if I'm looking at a worksheet that contains a pivottable, I can click on the pivottable and choose: Show pivottable toolbar Or I can click on View|Toolbars|Pivottable. ========= If that doesn't work, try two commands in the immediate window of the VBE: application.CommandBars("Pivottable").visible = true and then application.CommandBars("Pivottable").Position = msoBarBottom Pat wrote: I'm looking for the Pivot Table Toolbar - Is that the name to use or how can I find the correct name? Thanks Pat "Dave Peterson" wrote: So you know the name of the toolbar??? If yes, try this: Hit alt-f11 to get to the VBE. Hit ctrl-g to see the immediate window type this and hit enter: Application.CommandBars("YourToolbarNameHere").Pos ition = msoBarBottom Change the name to what you need. Then back to excel and look at the bottom of the screen and move it where you want. Pat wrote: I moved a toolbar off the screen and now can not find it. In the View Menu/Toolbars, it indicates that the toolbar is viewable, but I don't know where. Any ideas on how to locate? Thanks for the help! Pat -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Toolbar changes lost - help | Excel Discussion (Misc queries) | |||
| Lost Commands on Toolbar ie. File, View, etc. | Excel Discussion (Misc queries) | |||
| Lost Address area/toolbar ?? | New Users to Excel | |||
| I lost the cell view just below my toolbar. | Excel Discussion (Misc queries) | |||
| Lost Toolbar / Right click disabled | Excel Discussion (Misc queries) | |||
Linear Mode
