View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Desaivres Alain Desaivres Alain is offline
external usenet poster
 
Posts: 23
Default Size of CommandButton changing while not expected !

I have introduced some CommandButtons inside a spreadsheet, I was expecting
they would keep a proportional size while changing the zoom factor of the
spreadsheet displayed but sometimes it simply does not work!

The zoom function is activated from one of the CommandButton that launch the
following macro:
Range("zoneToAdjust").select
ActiveWindow.Zoom

One time, each time I was launching once more the zoom function, the
CommandButton size was reduced more than per 2! I have the feeling that the
fact I move the Excel window from one screen to another one not having the
same definition can be at the origin of the problem but really no certitude
at all... It's even not that easy to reproduce the problem...

Thanks if you have an idea about that problem...
Alain