Hi,

I'm a tinkerer in excel and know a (small) bit of VBA but could use some help.
I have the following challenge: I'd like to have a logo on the bottom right corner of my excel worksheet view regardless of zoom, resize, cell width and scrolling. So it will need to move with the user actions. I've tried a bit of VBA where on worksheet resize I read out the screen width and then give my shape the corresponding 'left' attribute for a nice placement. However, zooming and scrolling seem to be quite a different matter. Does anybody know of a way for me to achieve my goal?

--------------------------
my current simple VBA:


Public Winwidth As Long
Public WinHeight As Long

sub workbook_activate() 'but also on workbook_resize and various other triggers.
Winwidth = Application.ActiveWindow.Width
ActiveSheet.Shapes("GPV_Logo").Left = Winwidth - 80
WinHeight = Application.ActiveWindow.Height
ActiveSheet.Shapes("GPV_Logo").Top = WinHeight - 60

end sub

----------------------

Hope theres a solution! thanks in advance

Sierik