Window size
 

I'd like to write a code to dynamically resize the worksheet screen based on
the selected worksheet. For instance, if a user selects "worksheet1" then
size to 640x480 and if it's worksheet2 then size it to 1024x768.

Thanks

Window size
 

You should zoom your sheet. What you describe is unacceptable behavior in a
multitasking environment. You don't even know if the users's computer can
do any of those resolutions. If you did it on my computer, it would only
happen once.

--
Regards,
Tom Ogilvy

"matelot" wrote in message
...
I'd like to write a code to dynamically resize the worksheet screen based
on
the selected worksheet. For instance, if a user selects "worksheet1" then
size to 640x480 and if it's worksheet2 then size it to 1024x768.

Thanks

Window size
 

Good point. I didn't think it that way. Thanks for the feedback.. as always.

"Tom Ogilvy" wrote:

You should zoom your sheet. What you describe is unacceptable behavior in a
multitasking environment. You don't even know if the users's computer can
do any of those resolutions. If you did it on my computer, it would only
happen once.

--
Regards,
Tom Ogilvy

"matelot" wrote in message
...
I'd like to write a code to dynamically resize the worksheet screen based
on
the selected worksheet. For instance, if a user selects "worksheet1" then
size to 640x480 and if it's worksheet2 then size it to 1024x768.

Thanks