A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
The situation you mentioned is related to VBA code, you can refer to this article: Office VBA support and feedback | Microsoft Docs
The best place for asking programming related queries is Stack Overflow. Members and engineers over there are proficient in the knowledge of handling such situations.