Preventing scrolling
Preventing scrolling
(OP)
I'm writing an Excel app to find the area of a polygon pasted into a picture box. I move the cursor over a point and press the spacebar which sends the coordinates to a couple of cells. This works great until I get too many points and XL starts scrolling! As the coordinates are screen relative, its not good to have the picture scrolling around. Can I somehow prevent scrolling until I'm finished capturing all my points?
"We have a leadership style that is too directive and doesn't listen sufficiently well. The top of the organisation doesn't listen sufficiently to what the bottom is saying." Tony Hayward CEO BP
"Being GREEN isn't easy." Kermit
http://www.youtube.com/watch?v=hpiIWMWWVco
http://virtualpipeline.spaces.liv





RE: Preventing scrolling
RE: Preventing scrolling
Another possibility:
Sub LIMITSCROLL()
Dim mysheet As Worksheet
Set mysheet = Sheets("Sheet1")
mysheet.ScrollArea = "A1:R32"
End Sub
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Preventing scrolling
RE: Preventing scrolling
http://new
Rather than using mouse clicks you draw a polygon over the shape, and the program uses the coordinates of the polygon vertices, which gets around the scrolling problem.
The code is all open source, so it may give you some ideas, even if it isn't suitable for your application as is.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Preventing scrolling
Clyde, where is that feature. I can't find it.
Doug, I'll try your digitizing program. Sounds like that will do exactly what I want. Wish I knew about that yesterday, but then I wouldn't have gotten all that good DIY education. :-\
Super. Thanks all.
"We have a leadership style that is too directive and doesn't listen sufficiently well. The top of the organisation doesn't listen sufficiently to what the bottom is saying." Tony Hayward CEO BP
http://www.youtube.com/watch?v=hpiIWMWWVco
"Being GREEN isn't easy." Kermit
http://virtualpipeline.spaces.liv
RE: Preventing scrolling
RE: Preventing scrolling
h
(It was a new one for me as well)
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Preventing scrolling
"We have a leadership style that is too directive and doesn't listen sufficiently well. The top of the organisation doesn't listen sufficiently to what the bottom is saying." Tony Hayward CEO BP
http://www.youtube.com/watch?v=hpiIWMWWVco
"Being GREEN isn't easy." Kermit
http://virtualpipeline.spaces.liv
RE: Preventing scrolling
application.screenupdating = false
would do the trick.