I have some how set something up so, whenever I move from one cell to the next in a worksheet the display automatically jumps to the top of the worksheet.
I can scroll back down to enter into the new cell but it is annoying to have to do this at each cell move
How do I stop it please?
Also - a second thing - how do I get a sheet to open in a set zoom value (80%) so the the whole of the sheet it viewable rather than having to re-set the zoom each time.
Thanks for the help
David
Whether it's happening in a specific workbook or in all workbooks or even with the new workbook too?
Please confirm...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
It only happens in one workbook but in all the worksheets within it.Originally Posted by :) Sixthsense :)
I do have a macro running in the workbook that takes the name of the worksheet tab from a specific cell in the worksheet as you enter the worksheet but I cannot imagine that this is influencing anything
David
Hi, David,
do you mind showing all code from that workbook (maybe even attach a copy of it if ther eis no confidential material in it)? I would expect that there is a "home" command available anywhere like Application.GoTo
Please do not fully quote posts if they are directly above.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I am sure there is a code which makes the cursor to react in that way...
To See Code in This Workbook Module
- Select the workbook in which you want to see the code
- Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
- In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
- Right-click on the ThisWorkbook object, and choose View Code
Copy the code and share it with us for doing the necessary changes...
I did the View code on this workbook and there was nothing there.
I have attached the relevant workbook as I am at a loss to know what I have done
It is designed as a tracker spreadsheet for form tutors to track the progress of their students with their UK university applications
The information in the spreadsheet it bogus to allow it to be tested before the proper info is put into it.
Thanks for any help
David
Many of your sheets in that workbook containing the below code which is the root cause of this error...
Just do right click on sheet tab and select view code and if the above code is there then it will not allow you to move to the end of the sheet.
Please Login or Register to view this content.
Wherever you cant able to move then do right click on those sheet and click view code. Removing the above code will allow you to move...
Hi, David ,
after any movement of the cursor you freeze pane, and thatīs causing the cursor to jump up.
Maybe you should run through that procedure when opening up the workbook and leave it away from any sheet.Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 09-10-2013 at 08:32 AM. Reason: corrected code as Name is whatīs needed there
Yes it has worked - Thaks for all your help
David
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks