Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help requested for an Excel Toolbar command
I am seeking help in creating a custom command for a MS Excel XP toolbar.
In MS Word XP, I added a Next Window button to my standard toolbar, by going to the Tools menu, selecting Customize, Commands, Window & Help & then dragging the Next Window command to my toolbar. I open several documents, then simply click on Next Window to go to the next open document (sort of like scrolling between documents). I want this same "feature" in Excel, but when I get to the Window & Help section, there is no Next Window command to chose. I have tried a macro, but cant get it to work. My macro knowledge is minimal & I am unable to find the actual command that will allow me to go to a next window. Can anyone assist in creating this command or perhaps copying from MS Word? Appreciate any assistance. |
#2
|
|||
|
|||
Hi Dean,
Try: Sub Tester() ActiveWindow.ActivateNext End Sub --- Regards, Norman "Deanl5" wrote in message ... I am seeking help in creating a custom command for a MS Excel XP toolbar. In MS Word XP, I added a "Next Window" button to my standard toolbar, by going to the Tools menu, selecting Customize, Commands, Window & Help & then dragging the "Next Window" command to my toolbar. I open several documents, then simply click on "Next Window" to go to the next open document (sort of like scrolling between documents). I want this same "feature" in Excel, but when I get to the Window & Help section, there is no "Next Window" command to chose. I have tried a macro, but can't get it to work. My macro knowledge is minimal & I am unable to find the actual command that will allow me to go to a next window. Can anyone assist in creating this command or perhaps copying from MS Word? Appreciate any assistance. |
#3
|
|||
|
|||
Awesome! (& so simple!)
Thanks very much! Norman. "Norman Jones" wrote: Hi Dean, Try: Sub Tester() ActiveWindow.ActivateNext End Sub --- Regards, Norman "Deanl5" wrote in message ... I am seeking help in creating a custom command for a MS Excel XP toolbar. In MS Word XP, I added a "Next Window" button to my standard toolbar, by going to the Tools menu, selecting Customize, Commands, Window & Help & then dragging the "Next Window" command to my toolbar. I open several documents, then simply click on "Next Window" to go to the next open document (sort of like scrolling between documents). I want this same "feature" in Excel, but when I get to the Window & Help section, there is no "Next Window" command to chose. I have tried a macro, but can't get it to work. My macro knowledge is minimal & I am unable to find the actual command that will allow me to go to a next window. Can anyone assist in creating this command or perhaps copying from MS Word? Appreciate any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Can I add a borders toolbar to Excel 2000 like the one in Excel 2. | Excel Discussion (Misc queries) | |||
command button in excel will move when print. | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |