Forum Discussion

Ron_Summers's avatar
Ron_Summers
Copper Contributor
Aug 08, 2021

Creating the PERSONAL.xlsb workbook

Platform: Windows 10 Pro; Desktop PC; Office 365

 

When I try to create the PERSONAL.xlsb workbook by following the HELP instructions, at step 3, this message appears: 

 

Then, when I click [OK], this message appears:

When I click [OK], the empty workbook that was my starting point unceremoniously reappears.

 

When I then open Visual Basic in the Developer tab, there is no PERSONAL.xlsb as expected.

 

What am I doing wrong?

Macros and VBA
office 365

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 08, 2021

    Ron_Summers 

    Try the following:

    • Select File > Options.
    • Click Add-Ins in the navigation pane on the left hand side.
    • Select 'Disabled Items' from the Manage drop-down near the bottom of the dialog.
    • Click Go...
    • If Personal.xlsb is listed there, select it, then click Enable.
    • Close the dialog and the Options dialog.
    • Quit and restart Excel.

Resources