limit users view

**aron** · 01-10-2010, 08:32 PM

Hi!
I'm trying to write an application that at times will present the user with different views of the same worksheet. (Seeing different parts)

So what I want is to stop them from nosing around seeing whatever other data there might be.
Sofar my code scrolls to the right area, changes the size of the window, makes the user unable to scroll away BUT. the user can still change size of the view.
Can I somehow block this?
Or can this all be made in a much easier way?

**Leith Ross** · 01-10-2010, 09:58 PM

Hello Aron,

Welocme to the Forum!

Here is a simple macro to disable the Zoom on the menu.

Please Login or Register  to view this content.

**royUK** · 01-11-2010, 05:05 AM

Why not have all other data on a very hidden sheet?

**aron** · 01-11-2010, 02:41 PM

Thanks for the attempts to help but to be honest I tried that first macro and didn't notice any difference.

However I did play around with the recorder and wrote this that does work:

Please Login or Register  to view this content.

I'll be back with whatever my next problem might be

**royUK** · 01-11-2010, 02:47 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here