Lock Screen to current view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

on and auto_open routine I want to stop the user from being able to scroll
left and right as is contains data that I do not want them to have asscess to.

How can I stop them from scrolling right & left?

TIA

Chris
 
Chris,
Look at the .ScrollArea property of the worksheet.
Sheet needs to be protected for this to have an effect (I believe).
Also, I don't think this is a retained property, i.e. you have to set it
each time WS is opened.

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit User scrolling 3
Frames Scroll event causing cursor to move to first textbox 2
viewing big charts 8
Oversensitive touchpad on modern laptops 0
Position Userform In Cells Portion of Excel Only 1
Postion view 2
Selecting the Current Column ? 3
Scrolling in a form's listbox 1

Back
Top