Word

You see the Word VBA compile error “Sub or Function Not Defined” after moving a macro project from one computer to another or from an older version of Office. This error means the Visual Basic for Applications editor cannot locate a procedure that your code calls. The root cause is almost always a missing reference … Read more

You want a specific VBA macro to execute the moment you open a Word document. This saves time by automating repetitive tasks such as applying formatting, updating headers, or refreshing data fields. Word provides two built-in event triggers, the Document_Open event and the AutoOpen macro, that run code automatically when a document loads. This article … Read more

You enter the correct password for a VBA project in Word, but the project remains locked and you cannot view or edit the macros. This happens because the VBA project protection in Word has two layers: a password for viewing the project and a separate lock that persists even after the password is accepted. This … Read more

You have a set of VBA macros in Word that automate repetitive tasks, but they stop working when you open the document in Word for the web or share it with users who only have cloud access. VBA macros run only in the desktop version of Word, not in browser-based Office. Office Scripts are the … Read more

When you press F8 to step through a long VBA macro in Word, the debugger sometimes jumps over several lines of code without executing them. This makes it impossible to trace variable changes or confirm logic flow. The root cause is a known performance optimization in the VBA engine that skips lines it considers “dead … Read more

Applying a consistent style to every section of a long Word document manually takes too long and invites errors. Word VBA macros let you automate the application of paragraph styles, character styles, and list styles across all sections with one command. This article explains how to write and run a VBA macro that loops through … Read more

When writing VBA macros in Word, you might notice that the Range object and the Selection object return different start and end positions for what appears to be the same text. This discrepancy causes macro errors, incorrect formatting, and unexpected behavior in automated tasks. The root cause lies in how Range and Selection track content: … Read more

When a Word VBA macro encounters a runtime error, it stops execution and displays a default error dialog. This halts the operation, often leaving the document in an incomplete or corrupted state. The cause is the default error handling behavior in VBA, which treats any unhandled error as a critical failure. This article explains how … Read more

When you run VBA code in Word that responds to document events like Open, Close, or BeforeSave, you may see error 91: Object variable or With block variable not set. This error stops your macro and can be confusing because the code looks correct. The cause is almost always that an object reference, such as … Read more