Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2022, 08:57 AM
PatrickOfLondon PatrickOfLondon is offline Run Code when document is Activated? Or clicked anywhere in it? Windows 11 Run Code when document is Activated? Or clicked anywhere in it? Office 2016
Novice
 
Join Date: Oct 2022
Posts: 4
PatrickOfLondon is on a distinguished road
Default Run Word VBA macro whan a Word document is activated or re-activated...?

This was really useful, thank you.

I would like to know if there is a similar method for running a macro when a Document is activated or re-activated (rather than when the Word Application window itself is activated). Is there any way of doing that?

What I'm hoping for is something that works similarly to
Private Sub Worksheet_Activate()
for a sheet in an Excel workbook, so that the macro fires when a Word document is activated or re-activated while the Word Application remains running.



With thanks in anticipation...
Reply With Quote
  #2  
Old 10-15-2022, 09:42 AM
daneyuleb daneyuleb is offline Run Code when document is Activated? Or clicked anywhere in it? Windows 10 Run Code when document is Activated? Or clicked anywhere in it? Office 2016
Novice
Run Code when document is Activated? Or clicked anywhere in it?
 
Join Date: Dec 2021
Posts: 3
daneyuleb is on a distinguished road
Default

If I'm understanding you correctly, it seems it would work if you use the "DocumentChange" procedure (in that second step) rather than WindowActivate. So the sub (in the class module) looks like this:



Private Sub App_DocumentChange()
MsgBox "changed!"
End Sub

Everything else remains the same. This fires the sub every time you switch from one doc to another without leaving Word.
Reply With Quote
Reply

Tags
activate



Similar Threads
Thread Thread Starter Forum Replies Last Post
This copy of MS Office not activated chzuck Office 1 10-10-2021 03:10 PM
I clicked "this document" in VBA thinking it was a menu button, it said "saving", how can I reverse messgchr Word VBA 2 07-20-2020 06:52 PM
Is my Office 'activated' or not? mabel Office 6 08-01-2019 04:18 AM
Run Code when document is Activated? Or clicked anywhere in it? Retrieve the last activated document name. eduzs Word VBA 1 08-22-2017 03:11 PM
Hyperlink not activated by footpedal Donone PowerPoint 2 05-05-2014 04:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft