VBA, macros
You download a Word template that contains macros, but when you open it, the macros are disabled and the features they power do not work. This happens because Windows and Office apply security restrictions to files from the internet, blocking macro execution to prevent malware. This article explains why macros are blocked after download and … Read more
After a recent Microsoft 365 or Office update, you open Word and notice the Developer tab has vanished from the ribbon. This tab is essential for running macros, adding ActiveX controls, and creating form fields. The update often resets your ribbon customization or changes the default visibility of certain tabs. This article explains why the … Read more
When you write VBA macros in Word, the code may behave differently depending on the Office version (2013, 2016, 2019, Microsoft 365). Features like the new Comment API or the Document Inspector changed between versions. Without version detection, your macro will crash or produce wrong results on unsupported versions. Conditional compilation lets you write one … Read more
When you press Alt+F11 to open the VBA Editor in Word and run a macro, you may see a pop-up that says Compile Error: Method or Data Member Not Found. This error stops your macro from running and highlights a line of code in yellow. The root cause is usually a missing object reference, a … Read more
You want to add, remove, or modify custom dictionaries in Word without opening the Options dialog each time. Word stores custom dictionaries as .dic files, and the built-in interface only lets you manage them one at a time. This article explains how to use VBA macros to automate dictionary management, including adding new dictionaries, enabling … Read more
When you run a VBA macro to insert a Quick Part in Word, you may receive runtime error 5398 with the message “The requested member of the collection does not exist.” This error occurs specifically when the macro tries to access a building block that is not present in the target template or document. The … Read more
You need to protect parts of a Word document while leaving other sections editable by specific users or groups. Standard document protection in Word applies to the entire document and does not allow fine-grained control over individual sections. This article explains how to use Visual Basic for Applications (VBA) to apply section-specific protection that restricts … Read more
When you write VBA macros to insert building blocks such as headers, footers, or cover pages into a Word document, the programmatic access may return a different style than the one you specified. This causes the inserted content to appear with incorrect formatting, font, or color. The issue occurs because the building block’s underlying style … Read more
You need to automate Word but are unsure whether to use VBA or the new JavaScript Office Add-in model. Traditional VBA macros run inside the Word desktop application and rely on the legacy object model. The modern Word API is a REST-based interface that works across Word on the web, desktop, and mobile. This article … Read more
When you run a VBA macro in Word that uses the Range.Find method to search for a specific string, the macro may report that the text was not found even though you can see it on the page. This often happens when the search term spans a page break or a section break. The Find … Read more