Solved Windows 10 computers wont run excel macros

November 30, 2017 at 09:12:21
Specs: Windows 10
excel wont run macros on windows 10, run fine on all windows 7 computers.
Simple VB script embedded in excel, trust center has allow macros, still won't run

See More: Windows 10 computers wont run excel macros

Reply ↓  Report •

#1
November 30, 2017 at 12:37:33
What does "won't run" mean? Are there any error messages or is just that nothing happens?

I'm also not sure what you mean by "simple VB script embedded in excel". What, in general, is the code supposed to do?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
November 30, 2017 at 13:00:22
The excel spread sheet contains vb code that is supposed to run when you click on the box that says "click here to start" . In windows 10, does not matter if it is excel 2007 or excel 2010, it does absolutely nothing. The settings for ActiveX and Macros are all enabled. Works perfectly on any Windows 7 system.
It is supposed to pop up an entry window, where you input data that then goes into another sheet.
no errors, messages, nothing.

message edited by gardenwizard


Reply ↓  Report •

#3
November 30, 2017 at 15:12:31
✔ Best Answer
Try this simple test.

1 - Open a new workbook
2 - Right click the sheet tab for any sheet and chose View Code
3 - Paste the code below into the window that opens
4 - Go back to that sheet and select a different cell than the currently active cell

If you don't get a pop-up message, then it is directly related to VBA not running, i.e. it's not an ActiveX issue or anything related to your workbook, the other code, etc. At least you'll have narrowed it down, maybe.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  MsgBox "VBA works just fine"
End Sub

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
November 30, 2017 at 17:18:39
Thank you! that code did work, so maybe it is active X. I have no idea, and have spent far too long on this. ugh.

Reply ↓  Report •

#5
November 30, 2017 at 20:23:51
I don't do Windows 10 so I can't help with that. If I were you, I'd keep eliminating possible issues. Try one of these next:

Change the code so that it's not called by the button and just run it.

Create a new button and assign the macro to it.

Create new code (any code) and assign it to a new button.

Maybe the button lost the connection to the code or maybe no code will run via a button. Might point you in the right direction.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Ask Question