LinkBack URL
About LinkBacks
My 'controls' option is grayed out in the 'developer' tab. This a blank, non-protected worksheet. I have also enabled controls within the active x settings. I am using excel 2010. Has anybody experienced this before?
Thanks
My 'controls' option is grayed out in the 'developer' tab. This a blank, non-protected worksheet. I have also enabled controls within the active x settings. I am using excel 2010. Has anybody experienced this before?
Thanks
Hi sujithr25 and welcome to the forum,
I get a grayed out "Design Mode Icon" until there is a Module. I inserted a control on my sheet and then went to View Code. After a module is created then the Design Mode Icon becomes not-grayed.
Hope that helps.
Maybe, because you are working on an .xls workbook you can't insert a control on a worksheet itself?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Is the Controls button grayed out for all workbooks? If not check you do not have grouped sheets.
Also check worksheet protection
Hi. Thanks for the replies.
The button is greyed out for all workbooks. None of them are protected or have grouped
worksheets.
i have the same problem and it is driving me crazy. It is an xlsm, it is not protected and I do not have multiple selected. It worked fine till about a week ago, when all the macro buttons disappeared and I cannot use the insert function to get them back. The macros are still there and working, but it would be nice to have the button back.
The insert button only disappears for this file. I have the original saved from October and the insert button is fine on that one, but I really do not want to have to go back to that one and re-key months of data and adjustments.
Any help would be greatly appreciated.
Last edited by pugmac; 12-17-2012 at 08:44 PM.
pugmac...Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Oops, not sure what was going on here. What I posted doesn't seem to have anything to do with this post. I tought I was responding to another post. I do not even remember reading this post I replied too. OddOriginally Posted by FDibbins
Last edited by pugmac; 12-18-2012 at 12:21 AM.
After Googling half the day and performing all sorts of "fixes" to my "supposed" broken Excel 2013 I finally found the solution.
So simple, yet out of 100 +/- Googles only one person mentioned the "magic words," - insure your worksheet is not protected - DUH!
Note, even if your cursor is in an unprotected cell on the worksheet, the "insert control" within the Developer Tab is still grayed out.
I didn't try this but my guess is, even if one cell on a worksheet is protected, there are a lot of icons in the various Tabs/Ribbons
that will be grayed out.
Here's hoping your fix is as simple as unprotecting your worksheet.
Thanks for the feedback Sgt
Hey, hopefully it helped. Of course there could be other things wrong, but try the simple fixes first - who knows they may just work.
Am not guru like some of ya'll. While I was very, very conversant in Fortran IV back in the day, and the ole BASIC, VBA throws me
for a loop. I just can't seem to wrap my brain cells around it, even after taking 2 continuing ed classes from a most excellent
teacher. I have my fingers crossed the "light bulb" will come on sometime soon or am gonna end up with more gray hair! smile.
Best weeks wishes to all,
Sgt Rock (yep real Vet, Vietnam, 101st Airborne, platoon infantry sergeant - Mort)
Another thing to check that worked for me was to check that all COM addins are disabled.
What worked for me was to unshare your workbook. It must default to that when saving to a network location. Uncheck "Allow changes by more than one user..." -see images. Hopes this helps! Saved me a huge headache.
Unshare workbook.JPG Unshare 2.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks