Zoom Level Affects Shapes Positioning

  • I have been having a problem getting consistent square shapes positioned with an activecell.offset based VBA function. I've noticed that, for example, my script below is affected by the zoom level on the worksheet which is a real pain. at 50% magnification, everything was perfect. But when i changed to like 80% view, the position of the squares was way out. Is it normal for worksheet zoom and column/row sizing differences to affect the activecell offset values?


  • Re: Zoom Level Affects Cell Offset Value


    Drawing objects are on a different layer of the sheet than the cells, so it doesn't surprise me. Why don't you set the zoom to 100% before adding the shapes?


    The NoteText property has been deprecated in favor of cell comments.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • Re: Zoom Level Affects Cell Offset Value


    Quote

    Zoom Level Affects Cell Offset Value

    That's not true at all and very misleading. Why not use something like "Zoom Level Affects Shapes Positioning"?


    Please consider those who take the time to search. [fa]*[/fa]

  • Re: Zoom Level Affects Shapes Positioning


    ah, i didn't realise that the problem lie may lie in drawing objects being on a different layer of the sheet than the cells. So as Dave says, zoom doesn't affect offset value per se, but the position of shapes layers relative to cell layers.


    yes only performing function on 50% or 100% is possible. but if anyone happens to discover a formula that can compensate for the 'zoom effect' on shape position, please share.