Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Save Workbooks In Arranged Workspace. On the View tab in the Window group click Save Workspace. For Each w In ApplicationWorkbooks wSave Next w ApplicationQuit.
Click the View tab. 8 people found this reply helpful. When used the icon would open the two files.
On the View tab in the Window group click Save Workspace.
Arrange the workbook windows as you want them to appear when you open the workspace changing the size of each workbook window as needed. If you think you might want to return to a view you created you can save this preferred view as a workspace. Open all the workbooks you want to save as a group. Once done run the code.