cursor

Hello, Is there a way to keep a range of hyperlinks working on a protected sheet? I only want to select unlocked cells for protection please. This sheet is for filling out data so I want to keep the cursor in the unlocked region. Thank you, XJ

This post can be deleted as I figured out the solution, but the option to delete is no longer available. Regards Pete

Hi, I have set various ranges to be protected so only specific users can edit the ranges. Should they not be set to allow, they will be requested to enter a password. This all appears fine, however even without the sheet protected, and me having allow rights, the cursor will not enter the ranges...

I have a Lenovo laptop, and I find myself inadvertently inserting characters into my spreadsheets. I have already disabled the trackpad, and use only the red dot in the middle of the keyboard for moving the cursor around, but I still find all types of unwanted characters. I have Undo in the...

I have a need to use data that is entered into boxes on a web page form. If I copy and paste the web page form to a blank Excel 2000 sheet, I can see the data. I can click on a cells of data. But if I move off the data area to an empty part of the sheet and move the cursor with the arrow keys...

I tried finding an answer but couldn't so I hope this is not a duplicate of a post with an answer. On a newly created sheet when you tab across and then finally hit "enter" the cursor goes to the next row and goes to column A (first column in my sheet). But, on my protected sheet when I hit the...

Hi all, i received a excel file, in that some column are locked, means not to enter specific column like C1 to E1 even cursor is out of these column c1 to e1. when you try to cursor goes to c1 then it will goto directly f1. can anybody tell me how is this?

If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...

First off, I believe there is a previously answered post but I can't find it for the life of me. I am looking assign a short cut to a macro that places the cursor in the Name Box so I can enter the desired value. I don't want to use the dialogue box that appears when you press F3. I would like...

I have this Script for my text box and it's viewing as a hyperlink on the form but every time you click it, it put the cursor inside the text box...How do I hide the cursor within the text box...See below script: Private Sub Text1__Database_Click() Call Shell("""C:\Program Files\Microsoft...

Hockey spreadsheet, in column A I've got the game number and enter scoring info beginning column B. What I want to do is set up macro that navigates to first open cell and the takes the number in the last non empty cell, adds 1 then moves cursor right to a specific column. So on this sheet...

Hi there, I have a workbook where, when any cell is selected, it goes into "edit mode" - ie the cursor flashes at the end of the cell content I have a button in a "mini menu" where I want a 'fake' bullet point 'ChrW(&H25CF)' to be inserted where the cursor is flashing. I know that this is...

Hello, All I want to do is when I move the cursor to a cell, press F2 then add 2 characters. I tried starting a macro by clicking on the macro icon in the status bar. But, when I put the cursor in a cell with a value already in, like 'fragpct' and press F2 and add the two characters, in...

I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow. Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets. Thanks in advance if you come...

This is not a question, but demo of a method that works and is simple. When checking for methods to set the cursor to a particular position in a textbox, you will see the method: Private Sub Textbox1_Enter() Textbox1.SelStart = 5 End sub for instance to set the cursor after the 5th...

Macro needed to clear all data, color and lines under the cell that contains the cursor e g: if cursor is on a cell on line 10 when the macro is activated, all lines downward from line 11 is completely cleared of data, color and lines

HI, I have set numerous range passwords to enable certain people to edit. for soe strange reason, once activated the cursor will not move around the spreadsheet properly, its all over the place? Any ideas appreciated...

Hi, I have allowed edit ranges for a number of different people. Once setup I have then locked the cells and protected the sheet. When I try and cursor around now, the cursor is erratic taking me everywhere but to the cell i want to change? Am I correct to lock the cells? I dont see how else...

Thank you in advance. I am trying to help someone in my office who does a lot of manual data entry in excel. She is looking for a way to customize her excel so that her active cell is a difference color than the rest of the spreadsheet. Is there a way this can be done? We currently have...

Hi I created a form to enter first and last name (please see the pic in the link below). I have 2 questions: 1- I click on the first text box and enter the first name then pressing Enter will move the cursor to next box then I enter the last name. Then I press Enter then the cursor will go to...