I am making a calculator for my employees.
#1. I would like to lock certain cells so that they can not edit them or go into them and
#2. How do I progam cells to jump to another cell? Example, after inputing date in A1 I want the cursor to jump to C5 after hitting enter or tab.
Thank you!
Whether or not you will need VBA rather depends on which cells will remain "unlocked".
If we assume A1 & C5 are unlocked and all other cells locked, when protecting the sheet you can de-select "Select Locked Cells" at which point leaving A1 will navigate to C5.
Post back with more info. if necessary.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks