Today I was trying something different and I noticed that some of my Forms Controls in the Developer tab is greyed out and for the life of me I am not able to enable them? I googled and searched - nothing. The greyed out controls are Text box, Combo List and Combo Drop Down. Thanks.
1. Check your References
2. Stop Excel and delete C:\Users\....\Application Data\Microsoft\Forms\EXCEL.box
3. Try again
Capture.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Paul:
You may have misunderstood. I am not doing a user form. I am trying to add the Forms Control onto the spreadsheet and the Forms Control in the Developer tab is greyed out. The last 3 icons are greyed out.
hmm, I don't know if Microsoft disabled them? I checked my Excel 2016, those controls are also greyed out!
Yes, I did misunderstand
I don't know if they ever worked since I don't use them on a worksheet
https://support.microsoft.com/en-us/office/why-are-form-related-commands-or-controls-on-the-ribbon-disabled-80be06a7-45d9-4582-9544-dfe87ecb9494
Capture.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks Paul, well I used them before and I was trying to test something and then they are greyed out. Looks like MS did turned them off.
Posting Permissions
Reply With Quote
