Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone know why this won't work
-- Private Sub Frame1_Click() With Me.Frame1 Sel = Sel + 1 If Sel = 5 Then Sel = 0 Me.Frame1.PictureAlignment = Sel ..ScrollBars = fmScrollBarsVertical ..ScrollHeight = .InsideHeight * 2.5 ..ScrollWidth = .InsideWidth * 9 End With Me.Repaint Me.Label2.Caption = Me.Frame1.PictureAlignment & " " & Sel End Sub -- Only when Sel = 0 does the picture show, UNLESS I remove the scrollbar stuff. I've spent all day trying different methods and nothing works ! Can you only have a scroll bar if PictureAlignment = 0 ? I've just though of that - is that why ? ?? !!! Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |