Prevent Personal.XLSB from opening but keep Macros?

I would like to know if there's a way of preventing PERSONAL.xlsb from opening together with an excel file when Macros are used? Two windows at the same time are a nuisance sometimes.

EDIT: It opens even if I have macros disabled.

5

2 Answers

According to this page, you can simply click the View tab on the Personal.xlsb window, then click Hide. The personal workbook with your macros still launches in the background when you open a spreadsheet, but it's no longer visible.

Maybe try Unhiding, then Hiding, then close/save the Personal.xlsb.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy