Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel - Cannot use macros after upgrade from Win7 to Win10


  • Please log in to reply

#1
RogerMortimer

RogerMortimer

    Member

  • Member
  • PipPip
  • 45 posts

Spreadsheets mith macros that work ok in Win7 give the following message in Win 10 "Can't exit design mode because ' Commandbutton x'

 

Cannot be created.  A different value for X appears with each spreadsheet but the button specified is present.

 

Roger Mortimer


  • 0

Advertisements


#2
Vi-Sion

Vi-Sion

    Member

  • Member
  • PipPip
  • 76 posts

Hi Roger , just asking are you sure it's a windows 10 issue ?

you said it worked on windows 7,is it on the same pc ?

have you recently made any updates for excel ?


  • 0

#3
RogerMortimer

RogerMortimer

    Member

  • Topic Starter
  • Member
  • PipPip
  • 45 posts

Same pc no updates to excel


  • 0

#4
Vi-Sion

Vi-Sion

    Member

  • Member
  • PipPip
  • 76 posts
Hello again Roger, i've been hearing that this is happening because of a MS update, and that if you delete he file MSForms.exd from any Temp subfolder in the user’s profile your problem should be solved.
In order to do this you need to:

1.Close Excel.

2.Start Windows Explorer.

3.Select your system drive (usually C:)

4.Use the Search box to search for *.exd

4.Delete all the files it finds.

Then try again .
Hope this helps.
  • 0

#5
RogerMortimer

RogerMortimer

    Member

  • Topic Starter
  • Member
  • PipPip
  • 45 posts

File deleted but no change.

 

Thanks for trying, any other ideas welcome!

 

Roger Mortimer


  • 0

#6
paws

paws

    WTT Tech Teacher

  • Tech Academy Moderator
  • 523 posts
Have you had a look at post 6 here?:
http://www.excelforu...be-created.html
Regards
paws
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP