Remove & lock basic functions

[Scorpion Steve]

Hey all,
I am developing a command center for my office.
I am using excel 2007 which for my project, has only got one sheet!
This has an image as a background with a number of button that I have assigned Macros.
I am needing some help to completely turn off all function so that the sheet is always in one situation and locked.
I am familiar with locking cell and hiding functions but I need the following locked, removed or hidden:
1.Scrolling - I do not want anyone to be able to move across a few cell that I have hidden (which shuffles the image across)
2.Zoom - I do not want anyone to be able to zoom in on my application page.

Thank you in advance for any help given!
Steve
Ps I am very very new to VBA codes etc but am able to understand.
**PLEASE SEE IMAGE FOR EXAMPLE**

 

[Scorpion Steve]

 

[borgem]

It looks like the last response (ignoring the OP's final comment) in this forum answers the zoom issue. http://chandoo.org/forums/topic/how-to-restrict-zoom-in-and-out-disable-zooming

Preventing scrolling is easy enough. You can just hide everything but the cell range you want them to see and then protect the sheet so they cannot unhide it.

 

[Scorpion Steve]

Hi, Yeah thats what I am looking for, Ive tried it this and has opened to correct zoom %.
But I am still able to zoom in and out as well as scroll across the page!
:/

 

[borgem]

I can't speak to the zoom issue, but for the scrolling, I don't get why it isn't working. I have done the same on a sheet of my own and, although the scroll bar is visible, since nothing to the right or below is visible, there is nowhere to scroll to. Maybe this macro code will work more efficiently for you. Found it with a quick google search.

Private Sub ScrollLock()
ScrollArea = "A1:Z48"
End Sub

 

[Scorpion Steve]

Thanks,
Ive placed this in and saved.
I am still able to scroll out of the are. Could this be because I have hidden every other cell?
I have also protected the spreadsheet! Should it work without protecting it?

 

[borgem]

It should work either way, protecting it just prevents your users from unhiding the hidden area. I just double-checked mine and the other thing that I've done is to use the "split" option in the view ribbon and then drag the selection down to the corner of my area. Then click the "freeze panes" button and "freeze panes" option. Sorry for the oversight. This should do it for you.

 

[borgem]

It should work pre-Excel2007, but I can't recall the menu options to get you there.

 

[Scorpion Steve]

Absolutely perfect!
I have learned the freeze feature and that works great!
Now I have just got to work on zoom disable!
Appreciate that!
Thanks!

 

[borgem]

You're welcome. Good luck with the zoom. Unfortunately, it appears that holding ctrl and scrolling the mouse to zoom may not be preventable (according to some brief searches on google). Hopefully you'll have better luck than I did in finding a solution.