Hi,
I tried looking for different threads but couldn't find the correct code. Basically I am looking for a code that would achieve the following:
1. When specific excel (Test.xlsm) is opened by user, it opens in Full Screen View.
2. Any other workbooks (new/old) opened after or before opening the Test.xlsm is not impacted by this full screen view
3. The view does not reverts to default when Test.xlsm is minimized/resized/toggeled between different applications or other workbooks.
Can anyone please advise if all this can be achieved via VBA code and if yes, can you please share the code with me.
Thanks a lot in Advance
Amit
I tried looking for different threads but couldn't find the correct code. Basically I am looking for a code that would achieve the following:
1. When specific excel (Test.xlsm) is opened by user, it opens in Full Screen View.
2. Any other workbooks (new/old) opened after or before opening the Test.xlsm is not impacted by this full screen view
3. The view does not reverts to default when Test.xlsm is minimized/resized/toggeled between different applications or other workbooks.
Can anyone please advise if all this can be achieved via VBA code and if yes, can you please share the code with me.
Thanks a lot in Advance
Amit