Off-screen windows and a shortcut key solution ? ? ?

[Dennis]

In browsing this newsgroup I see that others have the same problem I
do: Excel windows opening with the title bar off the screen so the you
can't move or resize them. For those of us who use 2 monitors, this
happens all the time.

And, the work-around to this bug (it IS a bug) is to use the Zoom
Window command under the Window menu. (I assert that this is a bug,
and an easily fixable bug, since it does NOT happen in MS Word, i.e.,
windows saved on the second monitor in Word remember their location
correctly.)

So, regarding the work-around . . .

How do I assign a command key shortcut for Window > Zoom Window?

I know the process, i.e., to use the "Customize Keyboard . . ."
command under the tools menu. But, I can't find this particular
command.

Thanks for the help. This bug has existed in Excel for a few years
now, ever since Microsoft produced their OSX version of Excel (Office
X). Regular complaints, suggestions, and bug reports to the developers
haven't yet produced a solution.

But, I've gotta tell you MS Mac developers that as annoying as this
is, the improvements in the latest Office:mac 2004 are spectacular.
Now I'm really mad at you: I'm actually enjoying the new features and
I'm enjoying using Office:mac.

Dennis

 

[Paul Berkowitz]

So, regarding the work-around . . .

How do I assign a command key shortcut for Window > Zoom Window?

I know the process, i.e., to use the "Customize Keyboard . . ."
command under the tools menu. But, I can't find this particular
command.

You're right: there's no command for Zoom Window there, neither in Window &
Help nor in All Commands. Lots of other Zooms, but no Zoom Window.

In Panther, System Preferences/Keyboard & Mouse/Keyboard Shortcuts/All
Applications/Excel/Add should be able to do it, but it doesn't work. (This
seems to be true for most -or all? - menu items in Excel, Word and PPT.)

Rather amazingly, I have found I can AppleScript it via what's called GUI
Scripting. I say "Rather amazingly" because GUI scripting also tends not to
work for Excel, Word and PPT. I believe that it works here because this
"Zoom Window" menu item is really mapped to an Apple command - the green
button - not an MS command. That's also probably how it managed to get
omitted from Customize keyboard/All commands.

Anyway, the problem then would be that Excel has no Script menu with
keyboard shortcuts available like Entourage does. The script could be made
available form the system's Script menu, but that (so far) does not have a
keyboard shortcut implementation either.

There are 3rd-party utilities, in particular Keyboard Maestro, now made by
Stairways Software (who also make the great Interarchy):

<http://www.keyboardmaestro.com/main/> or via versiontracker.

Everyone I know says this is the best such utility. It can activate a
script.

So if you (or anyone) is still interested, and willing to go that far, I can
supply the GUI script that will zoom your Excel window.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[JE McGimpsey]

How do I assign a command key shortcut for Window > Zoom Window?

Zoom Window isn't exposed directly, for some reason.

However, you can put this macro in your Personal Macro Workbook, or
another workbook/add-in in your Startup folder, and assign a keyboard
shortcut to it:

Public Sub ZoomWindow()
Application.CommandBars.FindControl(Id:=843).Execute
End Sub

 

[Paul Berkowitz]

Zoom Window isn't exposed directly, for some reason.

However, you can put this macro in your Personal Macro Workbook, or
another workbook/add-in in your Startup folder, and assign a keyboard
shortcut to it:

Public Sub ZoomWindow()
Application.CommandBars.FindControl(Id:=843).Execute
End Sub

That looks a lot simpler. How did you track down Id:=843?

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[JE McGimpsey]

That looks a lot simpler. How did you track down Id:=843?

In the VBE's Immediate Window I entered:

? CommandBars(1).Controls("Window").Controls("Zoom Window").Id

 

[brooke]

http://www.ardice.com/Games/Video_G...line_Series/Ultima_Online/3rd_Party_Utilities