personal.xlsb file causing close-down problem.

[Trebor777]

HI, I am starting to learn macros using a user guide I have. The small macros I am developing are stored in the personal.xlsb file. No problems.

I am finding that when I close a workbook I have to close excel twice, the workbook closes OK, but the excel window stays open and I have to close it again.

No problem, but is this being caused by the personal.xlsb file ??

Thanks as always

Trebor

[smpita]

I had a similar approach when I started VBA development. I never encountered this issue. That said, I stopped using the personal workbook because when you open 2 copies of Excel at the same time, it would complain that a copy of the personal workbook was read only.

I solved that by getting rid of the personal.xlsb and making my code into an add-in, which was a simpler than I imagined. I took the code from my personal workbook and saved it as a .xlam file, then added a reference to my add-in. Detailed Instructions here: https://msdn.microsoft.com/en-us/lib...ffice.14).aspx and here https://support.office.com/en-us/art...ersion=Windows

My biggest challenge at that point was registering hotkeys. My add-in functions no longer showed up in the macro menu. Here's the solve for that. This needs to be in a standard module in your add-in if you want to register hotkeys.

Please Login or Register  to view this content.

This will call the myMacroSub when someone presses CTRL+e.

[smpita]

Looking at the official URLs that came up, I noticed the process is different from what I experienced. If the official instructions don't seem right to you, I added mine like this in Office 2010:

File -> Options -> Add-ins ->
Screen Shot 2018-01-06 at 10.56.07 AM.png

Go (button) ->
Screen Shot 2018-01-06 at 10.56.22 AM.png

Browse -> (browse to file)

It asks if you want to move it to Excel's "Add-in" location or just make a reference to the current location. Choose whatever works for you.

[smpita]

Just had an idea to test if it is your personal.xlsb is the problem. With Excel closed, browse to your personal.xlsb file in explorer. Move the file to your desktop and open Excel. If you still have the closing problem, it's not from the personal workbook. If the issue does go away, moving the code to an add-in will probably solve the issue.

[Trebor777]

Thanks for the ideas. Ultimately I think the macros I create will be saved within the workbook itself, and I can delete personal.xlsb. In the shorter term I could rename the file, see if the problem goes away. I'll let you know.

Trebor