Then multiple workbooks can be opened and macros run between them.
When you check "Enable Tabs for Excel," afterward, then the "Show all windows" option automatically becomes unchecked.
Hope this helps someone else! :)
If you have encountered Office Tab has gone or disappeared in Office applications under some rare circumstance, you can always try to bring it back according to the following methods.
Go to Office Tab Center, you can enable or disable the specific tab feature. You can access Office Tab Center by double clicking on the Office Tab Center icon on your computer desk. You can also access by clicking Start > All Programs > Office Tab > Office Tab Center. To make sure the Enable Tabs for Word, Excel, PowerPoint, is checked. Click “OK” to close Office Tab Center. If the problem is still out there, please go to next step.
In this case, I am going to use Microsoft Word 2010 for this troubleshooting. If there is no tab in Word, you should choose to access the Word Add-ins Manager to enable it manually. For Office 2010, Click File > Options > Add-Ins. For Office 2007, Click Office icon > Word Options > Add-ins.
2.1. To enable Add-ins, please choose the Add-ins type in the bottom of the above screenshot (Office Tab add-ins belongs to the COM Add-ins type), and then clicking Go…
Note: If you are using Microsoft Office 2007, please make sure both the Tabs for Word (32-bit) and Office Tab Helper are enabled.
Why Office Tab will become disabled sometimes? That’s because there are some other Office add-ins which is not compatible with Office Tab in your Office application. In this case, you should try to disable some other Office add-ins which you don’t need to use, and just keep Office Tab enabled.