Preventing scrolling

[BigInch]

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

 

[zelgar]

Have you tried using the Freeze Panes function?

 

[electricpete]

Freezing may do what you want if the area of interest is in the frozen portion of screen.

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.

 

[Clyde38]

Open the VBA editor and modify the ScrollArea for the sheet.

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[IDS]

BigInch - you can download a spreadsheet that does what you are looking for from here:

http://newtonexcelbach.wordpress.com/2010/04/14/how-to-digitise-a-scanned-image/

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/

 

[BigInch]

ePete, I realized that if I didn't print the values in any cells and just calculated the area as a part of the VBA program itself, scrolling didn't happen, so the problem kinda' went away there, but thanks. I'm sure I'll run into the scrolling problem again somewhere.

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
"Being GREEN isn't easy." Kermit

http://www.youtube.com/watch?v=hpiIWMWWVco

http://virtualpipeline.spaces.liv

 

[Clyde38]

Open the VBA editor (Alt F11). Select the worksheet you want and choose the properties view. See attached for Doug's spread sheet.

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[IDS]

More details on Clyde38's scrollarea tip:

http://excel.tips.net/Pages/T002669_Limiting_Scroll_Area.html

(It was a new one for me as well)

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[BigInch]

Ah ha. Properties page. Never noticed scroll area was there.

"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

 

[MintJulep]

Probably

application.screenupdating = false

would do the trick.