Windows 10: Excel VBA Signature SelfCert not work after Window 10 update

After window update before restart, there are 2 packs to be installed as shown below1 Feature update to Window 10, version 20H22 Intel - net 22.40.0.7Before restarting window, Excel works fine with macroAfter restarting window and installing packs, Excel does not work for following message'Macros are disabled because the security level is set to High'Does anyone have any suggestions?Thanks in advance

:)

 

DDE link in Excel crash when I open VBA in Excel wirh Windows10

Good Morning.

I,ve installed windows 10 about 20 days ago.

I've also Microsoft Excel 2007 and I use much VBA Excel and DDE links in my worksheets in Excel.

Before installing Windows 10 I use Windows XP ( with the same Excel 2007 thet I reinstall on Windows 10)

With Windows XP, some times when I need to change istructions in VBA, also if my worksheets was linked with DDE, I opened VBA VisualBasic and I can work in my VBA application.

No problems.

Now, with windows 10, when I open in Excel Visual Basic java links DDE Excel crash.

All works well ( DDE, Excel, and other software ) but whan I open visualbasic in Excel Java Crash.

Any suggest?

Thanks

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

VBA Excel Question

I'm going through someone elses code in VBA Excel - how do I know that "FIELD 16" is?

ActiveSheet.Range("$D$2:$R$5000").AutoFilter Field:=16, Criteria1:="="