View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Wind54Surfer Wind54Surfer is offline
external usenet poster
 
Posts: 16
Default Resolution change

Thanks for your response, but my code writing is not good at all.

What can I enter in the Open event to run something like:


If Resolution=1024x768 then

runmacro "ZoomIn"

Thanks,
Emilio

"Tom Ogilvy" wrote:

You could use the workbook_Open event

See Chip Pearson's page on Events:
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Wind54Surfer" wrote in message
...
Hi all,

I have a macro (zoomin) to change size of wsheet depending of my screen
resolution:

Notebook or larger LCD

Is there a way to call the macro when wsheet Open to adjust to the screen
resolution?

Thanks for any help,
Emilio