Hiding / Unhiding Personal Macro Workbook
Personal Macro Workbook will be hidden, by default. When you start Excel, the personal macro workbook is loaded but you cannot see it because it is hidden. You can unhide it as follows-
• Click the VIEW tab on the Ribbon.
• Click Unhide in the Window group
The Unhide dialog box appears.
PERSONAL.XLSB appears in the Unhide workbook box and click OK.
Now you can view the macros saved in the personal macro workbook.
To hide the personal macro workbook, do the following –
• Click on the personal macro workbook.
• Click the VIEW tab on the Ribbon.
• Click Hide on the Ribbon.
No comments:
Post a Comment