Home |
Search |
Today's Posts |
#1
|
|||
|
|||
placement of shape (image) in bottom right corner of viewport
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 Last edited by Sierik : September 1st 12 at 12:39 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate in bottom left corner | Excel Discussion (Misc queries) | |||
Can't get to bottom right corner of window to resize? I figured it | Excel Discussion (Misc queries) | |||
When i highlight cells, I USED to get total in bottom rt corner? | Excel Worksheet Functions | |||
Missing Sum at Bottom Right Corner | Excel Discussion (Misc queries) | |||
copy shape image into image control | Excel Programming |