Formatting the Visual Basic window in Excel Mac

Question

I am having problem locking windows such as the Immediate and Watch windows in Excel Mac. The windows originally were attached to the bottom of the grey work area in the VB window along with the code windows. I could resize, and enlarge/reduce them but they stayed at the bottom. I appear to have done something and now the windows either float independently of the VB window or they will only lock at the top.

Can someone suggest what I may have done to create this, and how I can fix it?

Thanks

Bill

Answer 1

Hi Bill,

I'm so glad that the problem has been solved. I made a conclusion for this issue specifically, which may benefit other community members in the future.

Issue description:

You can't seem to dock the panel except the top. The panel will float anywhere in the Visual Basic window in Excel Mac.

Issue environment:

Excel for Mac

Issue solution:

You can try to uninstalland re-install Excel for Mac on your side via this article. Because re-install may reset some settings in Excel application.

Best regards,

Jazlyn

Answer 2

Hi Mark:

I did try this, unfortunately with no success. I have just completed re-installing Office as Jim suggested and that has fixed the problem. Thanks for all the suggestions.

Bill

Answer 3

Hi All,

@Jim, thanks for sharing your idea. Based on Bill's reply, it seems that it didn't work for him. If you have any ideas about this problem, welcome to post back.

@Bill, since I can't find any other workaround for this problem, if you are really concerned about the position of the dock window, you may consider taking some time to re-install the Excel for Mac client. This will return your Excel to its default state.

Best regards,

Jazlyn

Answer 4

Thanks Jazlyn, I will give that a try

Bill

Answer 5

Have you verified that you have checked the checkbox for each of those windows?