Macro

[Marky]

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.

 

[gplhl]

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