Save and Close Workbook

[bmonique368]

Hello Everyone.

I hope someone will be able to assist me with this issue.

Each time I open my Ms Excel Workbook it shows the sheet it was on before it was closed. What I want to do is, on the click of a button, it will do three things: 1. save the file. 2. Return to a main page 3. Close the file.

Currently it does two of the three with the following code;

ActiveWorkbook.Close SaveChanges:=True

Is there a way to add the third task to the above code?

Your help will be highly appreciated.

Thank You!....

 

[JoeMo]

With Activeworkbook
.sheets("main page 3").select  'Put the correct name of the sheet between the quote marks
.close savechanges:= True
End With

 

[bmonique368]

Thank You Very Much..... It worked!!>>>>>

 

[JoeMo]

Thank You Very Much..... It worked!!>>>>>

You are welcome - thanks for the reply.