what to do if we want that cursor will automatically come to the column "A" when we reach to column "V".
what to do if we want that cursor will automatically come to the column "A" when we reach to column "V".
Hi,
You could either unlock all the cells in columns A:V and then protect the sheet.
Or
Use the following Sheet selection change event
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Did you try his 1st suggestion?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Richard gave you 2 suggestions, and I have already asked if you tried the 1st 1 yet???
i have tried both suggestions but it's not fruitful. actually 1st one is only locking the cells apart of column A:V, but i required that cursor will auto come on "A" column once the cursor is crossed to "V" column.
As well as locking the cells did you also switch on Sheet Protection ticking the 'Select Unlocked Cells' option.
If you've done both please upload the workbook in which you've made the changes so that I can identify why you say it isn't working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks