Hello; I would like to add four active x control command buttons to a worksheet on my desktop PC; when I try to do this (developer, insert), I get the message "cannot do this" - or words to that effect. However, on my wife's laptop with same version of excel (2013), I can insert a command button active x with no error messages. You expert help would be appreciated.
Regards Ron
Have a look Here !!!
http://blogs.technet.com/b/the_micro...-updates-.aspx
Thanks for your input, but that link was a bit too deep for my level of understanding. One point I should have added was the desktop PC is on Windows 8 and the laptop on 8.1; woul.d this be the reason?
Ron
No, it's the fact that, as that link said, there's a problem with some updates that Microsoft released. There's a link on that page to an article with a FixIt tool: http://support.microsoft.com/kb/3025036/EN-US
Remember what the dormouse said
Feed your head
ron,
The link boils down to having to delete some temp files from the computer, which got messed up with a microsoft update. You need to navigate to this folder:
C:\Users\YOURUSERNAME\AppData\Local\Temp\Excel8.0 (where YOURUSERNAME is the name you log into windows with.) Then delete any .exd files. Same for \Temp\vbe
After that restart excel and try again.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Many thanks for your help; I will have a look. Regards Ron
easiest solutions:
open your file explorer and go to the "C" drive. Search the "C" Drive for the following "*.exd"
Delete all files that appear as MSForms.exd
Problem solved
.exd files MAY not be indexed and may NOT be found in a search. best bet is to navigate to the folders as described and delete the files.
They WILL be recreated but they will be the correct versions.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks