Как я могу заставить Excel 2011 перестать открывать мою личную книгу макросов?

25351
Stuart Maxwell

С тех пор, как я создал пару макросов в Excel для Mac 2011, личная книга макросов открывается каждый раз, когда я открываю Excel. Как мне избежать этого?

С тех пор я удалил макросы, но при каждом открытии программы книга все равно появляется. Это раздражение, больше всего на свете, но я бы хотел его устранить.

3

6 ответов на вопрос

4
paulmorriss

В Excel 2010 для Windows вы можете скрыть данную книгу (вкладка «Просмотр», «Скрыть»), и она будет скрыта при перезапуске Excel. Попробуй это.

Woo-Hoo! Ты великолепен, Пол. Я открыл Excel, зашел в меню «Окно» и выбрал «Скрыть». Затем я вышел из Excel и сохранил изменения в Персональной книге макросов. Когда я в следующий раз открыл Excel, вместо PMW всплыло окно выбора шаблона. Спасибо за предложение! Stuart Maxwell 13 лет назад 0
2
PReinie

While viewing the Personal workbook, go to Mac's Excel 2011 "Window" in the menu bar and it should show that Personal is checked. If not, check it. Then use Hide in that same menu. This works through a restart.

Gleaned from source: https://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/excel-for-mac-personal-macro-workbook-locked-for/e9727ba3-7e9f-41dd-875b-6c304388968c

DO NOT DELETE the Personal workbook. It contains your macros and all kinds of stuff. Deleting it will cause Excel to make a new one but your macros won't be there. Yes it will make Excel not show it, but only because the default for Personal is to not show it.

I also see that the OP Stuart posted this earlier, but it was a short sub-entry so I didn't see it until after posting this. I would have deleted my post but I thought the reason for not removing the Personal workbook should be noted.

1
Jeff Chapman

The solution regarding deleting the macro workbook worked for me, but the instructions need to be adapted for the Mac (the poster is referring to Windows, but the OP asked about Excel 2011, which is a product for the Mac).

The file path containing the personal macros workbook on the Mac is:

/Users/[your user name]/Library/Application Support/Microsoft/Office/Excel

Removing the personal macros workbook from here solved the problem of Excel showing the personal macros workbook every time that Excel 2011 starts.

1
Soman

Удалить файл из моей системы. Путь C: Пользователи> «Идентификатор пользователя здесь»> AppData> Роуминг> Microsoft> Excel> XLSTART: Personal.

И используйте «Эта рабочая книга» в качестве макроса в настройках.

enter image description here

0
user308175

I had the same problem, but the solution above didn't work.

I found that some Excel add-ins were preventing me from hiding to the personal macro workbook.

After I disabled them, I retried the steps above and everything worked great.

0
Ken

With my upgrade to 2013 Office Pro I started having the same issue when opening an Excel file from the network. I did unhide on the blank instance of Excel and it was the personal workbook. After saving all my VBA scripts as notepad++ files I deleted all the modules.

This did not help either, however, now that I no longer need the personal workbook in VBA I deleted the file from my system. Path C: Users > "User ID Here" > AppData > Roaming > Microsoft > Excel > XLSTART: Personal

Now when I open Excel files from the network, or double click, the app opens only 1 instance.

:-)

Похожие вопросы