MACRO Enabled Workbook has inactive INSERT Tab and Insert button icon function on developer tab is greyed out

Question

I have an excel 365 Macro Enabled Workbook which is shared between 8 to 9 people. Every 2 months there is an issue that BUTTON which i have made and connected with the MACRO becomes inactive. If I run the MACRO manually then it works. But INSERT Tab and the INSERT Control Function on the DEVELOPER TAB are greyed out.

Answer 1

You can ask Excel VBA questions in the Excel forum at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel?sort=LastReplyDate&dir=Desc&tab=All.

It might also be worth asking in the Q&A forum, for example at https://learn.microsoft.com/en-us/answers/tags/178/office-excel.

If you choose to post in more than one place, always include links to duplicate threads.

Answer 2

Hello Noman Mirza1,

Welcome to the Microsoft Community I wish I could handle your problem, however, it is more suitable for publishing on Microsoft Learn (English only), more users post these issues there, you can click on "Ask a question", there are experts who can provide more professional solutions in that place.Here is a link to the forum where you can raise specific scenarios and share your idea to help solve the problemSincerely hope that your question will be dealt with appropriately after contact the correct department. Thank you for your understanding.Best wishes,Lucia Wu - MSFT | Microsoft Community Support Specialist