• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Key Board short cut to reach end of file in Multiple worksheets

S

SANTHOSH

Member
@Dear All,

I have a file having 10 worksheets. Here, CTRL + Page up will go to previous worksheet. and CTRL + Page down will go to Next Worksheet. This is in excel 2003.

Is there any keyboard shortcut to reach worksheet 10 from worksheet 1 in a single step ?


SANTHOSH
 
Hi Santosh ,

If there isn't one , you can make your own.

In the ThisWorkbook section of the VBE , insert the following macro :
Code: 
Public Sub GoTo_Last_Worksheet()
          Worksheets(Worksheets.Count).Activate
End Sub
You can assign a keyboard shortcut key , say l ( the lower-case letter L , for last ) to it , so that pressing CTRL l will take you to the last worksheet.

Narayan
 
@SANTHOSH

Please Follow the Below Instruction :

1. Open your file

2. Press Alt +F11

3. In the Insert option select Module

4. Copy the Given Code and paste it

5. Close the VBA Project Window

6. Now press the Alt +F8 and run the code

Hope it clear

Thanks

SP

Note: Due to Net problem my post was not posted
 
Last edited:
Dear Santosh

Please open your desired excel, in which you wants to put this macro. Press Alt+F11 to open VBE editor. Then left side there will project explorer. You can see Thisworkbook object. Double click on it to open the editor. Then a blank window will appear. You paste the above code there. and close it

To assign your desired shortcut key: Press Alt+F8. then a macro window will open. In above combo box, select your macro i.e GoTo_Last_Worksheet select and click option button in left hand side. There you can assign your desired key to use with it ctrl.

Hope you can understand :)
 
You must log in or register to reply here.
Back
Top