But apparently that was not enough, the Excel view need to be widely again to full screen view. Unfortunately on Microsoft Excel 2010 version, that feature is not available by default.
Personal Macro Workbook is a workbook that contains the spcial Excel system named PERSONAL.XLSB. This workbook will be formed if the user create Macros by Recording, and save it in the Personal Macro Workbook.
Personal Macro Workbook is stored in a special folder, according to the user who is logged on. For example, the folder path on my computer is:
This workbook is opened automatically when Excel starts, It's just hidden so that it looks as if there is no open Excel files. How to display it, on the View tab Window category click Unhide then Unhide dialog box is displayed. select PERSONAL and click OK.
If you do not find the Personal Macro Workbook in the folder path or by Unhide, maybe you have never created Macros by Recording. So before you going to the next step, you have to create Macros by Recording.
The following are the steps to coding the macro :
- On the Developer tab Code category select Visual Basic, so Visual Basic window is displayed.
- On the Project taskpane click VBAProject (PERSONAL.XLSB), then on Insert menu select Module and write the following script:
End SubSub FScreen()
If Not Application.DisplayFullScreen Then
Application.DisplayFullScreen = True
Application.WindowState = xlNormal
Application.WindowState = xlMaximized
- If it is completed, close the Visual Basic window and return to Excel. On the Developer tab Code category select Macros, so Macros dialog box is displayed.
- Select the macro that we created earlier and then click the Options button. When you choose a character for the shortcut key make sure its not same with the default Excel shortcut key. For example I choose the key combination Ctrl + Q and then click OK.
- Now let's try it, press Ctrl+Q on the keyboard, Excel display will change to full screen view, press Ctrl+Q again to return to the original view.
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.
Community Solutions Content Disclaimer
Article ID: 2779060 - Last Review: Apr 1, 2013 - Revision: 1