When the user uses the remote desk of the laptop(the system of the laptop is windows 10 1903 rdp) to connect to another computer, the excel document with Macros cannot open or save(the version of the office365 is latest).

it is not a secret that the VBA protection password is very weak, it is very frustrating that I can't defend properly a sensitive code in the one of the biggest and popular software (Excel) in the world.
improving VBA protection is a game changer for lots of people.

Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

Don't go destroying developer's programs, just add interoperability, functions, and facelift.

opening the Microsoft

Please support Unicode font in VBA.

Thank you!

While editing VBA code within the Developer window, there should be some basic syntax highlighting such as paired parentheses. This would help while coding complex nested conditions.

well, visual basic great language loves it but Microsoft seems to have abandoned the language. C# is clearly the new emphasis so, therefore, start the move to make C# the default language for the office products. plus there is an opportunity to increase the performance and features of the macro language. allowing for the creation of exportable modules and even binary macros that run faster or can be more easily exported to different machine

Workbook.SaveCopyAs works only for the Old Excel Formats (<=2003)
Does not work for .xlsx, ,xlsm, .xlsb

Please upgrade to this to work for New Excel Formats (>=2007)

Sam

My problem is: I am getting Hungarian text from a textbox of a userform. If the text has some special Hungarian characters, like á, é, Ő, Ű, etc and I print out this string, I can not use it with another program, which expects encoding UTF-8
Can I somehow change the encoding of a string value in a VBA macro?
(I am using Office 365 on Windows 7 and Windows 10 operating system)

Active cell wont move when manually select a range using control-shift-xlup or other cursor keys. For example when we select a range from down-right corner to the top-left corner using control-shift-xlup and control-shift-xlleft, active cell is still at the down-right corner. While active cell seems to move to the top-left corner when we execute the same key sequences during a macro.
Thus it is difficult to reproduce the same behavior by using "Record macro".

Legacy versions of Excel (i.e. those prior to Office 365) enabled you to suppress Autoopen macros from deploying by holding the SHIFT key when opening the corresponding Excel workbooks. This functionality appears to have been lost in Office 365, as holding SHIFT when opening an .xlsm file does not stop the Autoopen macro from running.

Please can you reinstate this, as its absence feels more like an error or omission than anything else. Thank you ! :)

There is an annoying bug in microsoft excel vba, when using sendkeys, Numlock turns on! Please fix this bug

Es necesario que la propiedad de month view calendar se encuentra disponible en versiones de EXCEL mayores al 2013, ya que facilita la selección de fechas validas. Cómo puedo sustituir esta propiedad en una macro de excel?

Currently you can only reference comments in vba by their index number, if you know them. There is no known way to determine the comment index number by vba but maybe through a for-next loop searching the text for a known piece. It is possible to name a comment(shape). Since comments do not always get created by the same order or are in the same place, inserting data above or to left e.g., allow the comment to be selected/manipulated by it's shape name.

VBA doesn't check the maximum length of every text line when importing a module (.bas file). This can cause an issue when saving the VBA project inside VBA when the text line of the .bas file is higher then allowed, which can lead at the end to a full crash of Excel. This is a major issue.

Previously Excel Add-ins: You could use the Zip Code Conversion Wizard to bulk convert, but Office 365 Excel is out of system requirements and want a compatible add-in.

タイトル
Office 365 Excel 対応の郵便番号変換ウィザードのアドインを用意してほしい。

内容
以前は Excel アドイン: 郵便番号変換ウィザードを利用して一括変換することが可能だったが、Office 365 Excel はシステム要件外のため、対応したアドインを用意してほしい。