Private Sub Workbook_Open

[Carole]

This is the code that I have in the VBAProject window on "ThisWorkbook" object.

Private Sub Workbook_Open()
Worksheets("Start").Activate
Range("A1").Select
End Sub

However, when I close the workbook and re-open it, the "Start" worksheet is not the one that appears.

Please take a look at the file

Thank you

 

[Hui]

It works perfectly

You have to enable macro's when it asks you

 

[Carole]

Thank you for your quick response!

It does not ask me to "Enable macro?". I looked at my macro settings in
File - Options - Trust Center - Trust Center Settings - Macro Settings
and it is set at Disable all macros with notification

I am not quite comfortable at selecting Enable all macros....

Suggestions?

Thanks again

Carole

 

[Carole]

Ok this is getting very weird.

If I make a change in the workbook, save the change and then exit the workbook, when re-opening the workbook the macro does not kick in.

However

If I make a change in the worksheet and press the "x" in the right-hand corner, excel asks me if I want to save the workbook? I say yes. Then when I reopen the workbook the macro kicks in and works fine.