Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Cursor does not move on one sheet in protected workbook
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="pseudo_pro, post: 11430689"] What I have found that I think will work is to write a macro which will control the movement of the cursor. I am not very strong in macro writing, so any help would be appreciated. There are two sheets that require input from the user. The first is a PROFILE sheet which asks the user to input specific information relative to their business plan. Once input, it does not need to be changed unless something changes in the business. (This is the sheet that is NOT allowing cursor movement at the moment and hence the need for a macro.) Here are the cells in order of their needed input: PROFILE!C3 PROFILE!C4 PROFILE!C5 PROFILE!C9 PROFILE!C10 PROFILE!C11 PROFILE!C12 PROFILE!C13 PROFILE!C14 PROFILE!C18 PROFILE!C19 PROFILE!C20 PROFILE!C28 PROFILE!C29 PROFILE!C33 PROFILE!F3 PROFILE!F5 PROFILE!F11 PROFILE!F12 PROFILE!F14 (this field is a drop down using validation) PROFILE!F15 PROFILE!F20 PROFILE!F29 Ideally, I would also like a prompt to save the inputs on this screen in this macro as well. [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Cursor does not move on one sheet in protected workbook
Top