Thank you for the feedback!
--
Gary''s Student - gsnu200821


"Farhad" wrote:

Thanks Gary! it worked great
--
Farhad Hodjat


"Gary''s Student" wrote:

Once you have opened a workbook, it becomes the Active workbook. So:

Sub lastone()
Sheets(Sheets.Count).Activate
End Sub

should work just fine
--
Gary''s Student - gsnu200821


"Farhad" wrote:

Hi all,

my problem is to know how can i activate the last tab of an excel file in my
code i am openning several excel files one by one (not at the same time) in
my code and need to activate the last tab of each of them when the file is
open i am usung the code below which i found in MS Excel help but it doesn't
work everyone help me please.

ActiveWindow.ScrollWorkbookTabs Position:=xlLast

thanks,
--
Farhad Hodjat