Excel 2007 : Prevent Worksheet Scrolling

Is there a way to 'prevent' a worksheet from scrolling?

I have created a worksheet, but it will appear differently on users pc's based on their screen resolution. I would like to be able to only show the horizontal scrollbar if it is actually required because the user's screen resolution isn't high enough to show the whole screen.

I can turn the scrollbars off in the advanced settings, but this doesn't prevent the sheet from scrolling, is ther any way to achieve this if a specified number of columns can be viewed without the need to scroll and to then show the horizintal scrollbar if not?

I tried that one already, but it doesn't prevent the worksheet from scrolling with the mouse, again, not a big deal, but would just be a nice touch...

JapanDave,

Many thanks, I'll give this a go...