Disable Scroll Bars, and Set Screen Size.

**t0m46** · 09-02-2010, 05:17 AM

Hey all,

Is there a way to disable the scroll bars in excel so the user cant move from the area that they see??

also is there a way if you have to set the window size of a workbook? so everythime you open the workbook it only fills the left half of the screen and opens another workbook to fill the right half of the screen?

Thanks

**snb** · 09-02-2010, 05:31 AM

Use Scrollarea (a worksheet property )

**t0m46** · 09-02-2010, 05:34 AM

Hey, Thanks

Have Done it now. I used this Code to set the Window Size

Please Login or Register  to view this content.

And this to set the Scroll area so that you cant move from this area.

Please Login or Register  to view this content.

Thanks.

Disable Scroll Bars, and Set Screen Size.

LinkBack

Thread Tools

Rate This Thread

Display

Disable Scroll Bars, and Set Screen Size.

Re: Disable Scroll Bars, and Set Screen Size.

Re: Disable Scroll Bars, and Set Screen Size.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions