Share via

How to set default References in VBA Excel

Anonymous
2019-08-06T06:06:50+00:00

Hi,

I have a question regarding how to set default referecens in VBA Excel.

As you can see the image below, by default, it will auto check four references whenever I create a new excel file. I will like to uncheck OLE Automation and Microsoft Office 16.0 Object Library as I dont use it. How to make it as uncheck as default as it will be hassle to uncheck for every excel file I used. Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-08-06T08:08:37+00:00

    Hi WaiHong_Ng,

    Based on your description, you tend to change default Reference in VBA Editor without OLE Automation and Microsoft Office 16.0 Object Library. I also found a similar thread for Office 2010 to create a macro-enabled template for Excel. Based on my test, the solution also works on Office 365 Excel client when you open the created template file on Excel client next time. You can check here for more details to achieve that.

    Best regards,

    Dihao

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-08T09:16:44+00:00

    Hi WaiHong_Ng,

    Did you try the method above to create a macro-enabled template? Dose the default references be changed? If you have any other concern, please reply here and share the detail with us.

    Best regards,

    Dihao

    0 comments