Hello All,
I am testing out some macros in the beta version of Excel 2007. I can't
seem to find the command to size with window in Excel 2007. Help doesn't
help. Is that command still around in Excel 2007?

Thanks,

Bill

They've removed it, and I've already told one client not to upgrade until
I've figured out a decent workaround.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bill" wrote in message
ink.net...
Hello All,
I am testing out some macros in the beta version of Excel 2007. I can't
seem to find the command to size with window in Excel 2007. Help doesn't
help. Is that command still around in Excel 2007?

Thanks,

Bill

You might look here as well:

http://blogs.msdn.com/excel/archive/...28/724641.aspx

--
Regards,
Tom Ogilvy


"Bill" wrote in message
ink.net...
Hello All,
I am testing out some macros in the beta version of Excel 2007. I can't
seem to find the command to size with window in Excel 2007. Help doesn't
help. Is that command still around in Excel 2007?

Thanks,

Bill

The blog entry states "The Zoom to Selection command can be used to achieve
similar results." If you are using mouse events on a chart sheet, however,
no amount of zooming will make the translation of mouse position to chart
coordinates work properly. This is what broke because of the change.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tom Ogilvy" wrote in message
...
You might look here as well:

http://blogs.msdn.com/excel/archive/...28/724641.aspx

--
Regards,
Tom Ogilvy


"Bill" wrote in message
ink.net...
Hello All,
I am testing out some macros in the beta version of Excel 2007. I can't
seem to find the command to size with window in Excel 2007. Help doesn't
help. Is that command still around in Excel 2007?

Thanks,

Bill

Jon,

I have to admit that I don't know anything about Office 2007, but I ran
across this website that might be of help...

http://pschmid.net/blog/2006/10/09/58

Then look for "The size of the Ribbon, screen real estate, ribbon scaling
and minimization "

Maybe this will help out...

--
Mark Ivey

UoP e-mail:
Personal e-mail:
"Jon Peltier" wrote in message
...
The blog entry states "The Zoom to Selection command can be used to
achieve similar results." If you are using mouse events on a chart sheet,
however, no amount of zooming will make the translation of mouse position
to chart coordinates work properly. This is what broke because of the
change.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tom Ogilvy" wrote in message
...
You might look here as well:

http://blogs.msdn.com/excel/archive/...28/724641.aspx

--
Regards,
Tom Ogilvy


"Bill" wrote in message
ink.net...
Hello All,
I am testing out some macros in the beta version of Excel 2007. I can't
seem to find the command to size with window in Excel 2007. Help
doesn't help. Is that command still around in Excel 2007?

Thanks,

Bill

No, the XY values returned by the mouse events are deterministic only if the
chart sheet is sized to window. If it's not sized to window, you cannot make
sense of the numbers. This occurs in 2003 as well: using Sized to Window, it
is simply an exercise in algebra to locate a rectangle according to mouse
clicks; not using Sized to Window means you don't know what the reference
point is, and the formerly useful code fails.

I built a program that allowed the user to select a rectangular region of a
chart in order to zoom in on a selected region. Based on the mouse down,
move, and up events, the program drew a bounding rectangle to guide the
user. With Sized to Window the rectangle worked perfectly, without, it was
erratically and randomly drawn. In Excel 2007, there is no longer an option
that allows for reliably drawing the rectangle.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mark Ivey" wrote in message
...
Jon,

I have to admit that I don't know anything about Office 2007, but I ran
across this website that might be of help...

http://pschmid.net/blog/2006/10/09/58

Then look for "The size of the Ribbon, screen real estate, ribbon scaling
and minimization "

Maybe this will help out...

--
Mark Ivey

UoP e-mail:
Personal e-mail:
"Jon Peltier" wrote in message
...
The blog entry states "The Zoom to Selection command can be used to
achieve similar results." If you are using mouse events on a chart sheet,
however, no amount of zooming will make the translation of mouse position
to chart coordinates work properly. This is what broke because of the
change.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tom Ogilvy" wrote in message
...
You might look here as well:

http://blogs.msdn.com/excel/archive/...28/724641.aspx

--
Regards,
Tom Ogilvy


"Bill" wrote in message
ink.net...
Hello All,
I am testing out some macros in the beta version of Excel 2007. I
can't seem to find the command to size with window in Excel 2007. Help
doesn't help. Is that command still around in Excel 2007?

Thanks,

Bill