VBA window excel for Mac Office 365

Question

My VBA project explorer window is floating and if I move it to the upper left corner of the editor window it expanse so it goes completely across the editor window. My properties window does the same thing.

Office 365 and it's up to date

Answer 1

Jason,

I found it! There is a second "preferences" tab under "Excel" when the VBA window is opened.

Thanks for your help.

~Bill

Answer 2

Hi Bill,

Thanks for reaching out.

If my understand is right, your VBA project explorer window and properties window is floating.

As we test, when you open Excel->performance->Option->Docking you may find Project Explorer and Properties Window.

You should enable both options, then restart Excel.

If you have any updates please share with us, we will try our best to help you.

Regards,

Jason

Answer 3

Jason,

Thanks for the quick response. I am on a Mac and apparently Excel for Mac does not have the performance tab and options are apparently "preferences" on a Mac. There is nothing I can find in the preferences tab that takes me to a docking menu. If it means anything how this started was I clicked on the "project explorer" button in the VBA window.

I am extremely frustrated and about ready to delete and reinstall my Microsoft Office to try and fix this.

Regards,

Bill

Answer 4

I found it but I still have a problem with the Project and properties windows being the full width of the VBA window.

Answer 5

Hi Bill,

Apologize for the late reply!

Based on your description, it was caused by the float window.

We suggest you that set the properties window as float window first with the previous steps, then you can adjust the float window size by yourself.

After that, follow the steps to remove the float window, it will be ok.

I hope this suggestion can help you and welcome you back to share with us.

Regards,

Jason