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

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 of for example Cell A1:D10.









  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-23 12:00, Marky wrote:
    Is there a macro I can use, that opens an excelsheet alway on the same sheet of a workbook.??
    Yes


    Open the VBA editor, double click on ThisWorkbook for the workbook that you would like to have a specific sheet activated on and paste in this code:

    Private Sub Workbook_Open()
    'Activates a named sheet when the workbook is opened.
    ' Rename Sheet2 with the name of the sheet you would like to activate on opening.
    Worksheets("Sheet2").Activate

    End Sub



    Second question: Is it possible to write a macro that lets you always move from cell to cell by useing tab Within a range of for example Cell A1:D10.
    If you unprotect the range that you would like to tab to and then protect the sheet, this will allow you to use tab to go between unprotected cells.


    Regards,

    Gary Hewitt-Long


    [ This Message was edited by: gplhl on 2002-02-24 03:01 ]

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
  •