Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a macro I can use, that opens an excelsheet alway on the same sheet of a workbook.??

    Second question: Is it possible to write a macro that lets you always move from cell to cell by useing tab Within a range for example Cell A1:D10.



  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The first one will take you to cell A10 if you put it on the This Workbook:

    Sub Workbook_Open()
    Application.Goto Reference:="Sheet1!RC"
    End Sub

    Put this one on the worksheet.

    Sub GtRng()
    Range("A1:D10").Select
    End Sub

    Anytime you select a range, then do your entry, it will remain within your range, whether you hit enter or tab, until you click outside of that range.

    ~Anne Troy

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'll leave the second question to someone else because I'm not entirely sure of my solution.

    As to the first, you can use hyperlinks to goto a specific location in a workbook. Check out the Excel help on Hyperlinks to do this.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •