Hi everyone and thanks in advance for the help.
I've a spreadsheet that we use like a data entry screen. I need to disable the left-right scrolling to prevent the users from using the wrong items in columns starting from AA. We still need to scroll up and down though.
Prehaps this change event
To add code right click the sheet then select View code and paste the below code. Change sheet name to your change name
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Sorry but the code:
PLEASE ALWAYS WRAP CODEPlease Login or Register to view this content.
didn't work. I can still scroll past column AA. The data entry area starts in col A and the formula calculation area starts in col AA. Both looks the same. Although I've locked my cells and users can only access the unlocked cells where they enter the data, there are users that scrolls to col AA and they would then complain that they can't enter their data. Therefore my need to disable the scrolling.
Last edited by VBA Noob; 04-02-2007 at 01:25 PM.
How about hiding all columns from AA outward?
ChemistB
If you want to prevent incorrect entry, why not Protect the sheet, and disallow users from selecting protected cells?
The cells are all locked and protected except for the entry cells. For some reason, the users always go to col AA even though they were told not to. Anyway hiding the columns worked perfectly. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks