<div>
What is the issue?<br />
<br />
Kevin
</div>


<div>
Hello Kevin,<br />
<br />
I have multiple files in a folder. Each file has zillions of tabs. And I see that when I open each file, the last tab opens up in most of the files. So I would rather prefer when I open each file, that the first visible tab appears, not the last one? Get it?
</div>


Hello Kevin,

I have multiple files in a folder. Each file has zillions of tabs. And I see that when I open each file, the last tab opens up in most of the files. So I would rather prefer when I open each file, that the first visible tab appears, not the last one? Get it?

<div>
Here is another one <br />
<a href="https://www.experts-exchange.com/questions/28163307/Get-Summary.html" rel="ugc">https://www.experts-exchange.com/questions/28163307/Get-Summary.html</a>
</div>


Here is another one
https://www.experts-exchange.com/questions/28163307/Get-Summary.html [https://www.experts-exchange.com/questions/28163307/Get-Summary.html]

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
&nbsp;VBA Issue<br />
There are multiple sheets in a workbook. There are multiple workbooks in a folder. <br />
While iterating through each workbook, do this &gt;&gt;<br />
Activate the first worksheet which is also visible and then save the workbook.<br />
Reason – several of the workbooks I open , are showing the last sheet as activated when I open them.
</div>
</div>


Hello

 VBA Issue
There are multiple sheets in a workbook. There are multiple workbooks in a folder. 
While iterating through each workbook, do this >>
Activate the first worksheet which is also visible and then save the workbook.
Reason – several of the workbooks I open , are showing the last sheet as activated when I open them.

vba activate

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.