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

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

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