Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2018, 03:19 AM
eduzs eduzs is offline View/edit macro in DOTM file. Windows 10 View/edit macro in DOTM file. Office 2010 32bit
Expert
View/edit macro in DOTM file.
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default View/edit macro in DOTM file.


Is there a way to view/edit a VBA macro code stored in a dotm file in the word startup folder besides opening the dotm file?
If I try to view the code with a opened blank document word returns a error message that the project can't be show.
Thanks
__________________
Backup your original file before doing any modification.
Reply With Quote
  #2  
Old 04-12-2018, 01:56 PM
macropod's Avatar
macropod macropod is offline View/edit macro in DOTM file. Windows 7 64bit View/edit macro in DOTM file. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you double-click on the template, for example, or use any of the other available methods to create a new document from it, you can access the template's code by pressing Alt-F11.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-12-2018, 03:45 PM
eduzs eduzs is offline View/edit macro in DOTM file. Windows 10 View/edit macro in DOTM file. Office 2010 32bit
Expert
View/edit macro in DOTM file.
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

I was unable to view the vBA project from the doc1.dotm file in a new document created from doc1.dotm.
To open the project I still have to open doc1.dotm itself.
I did not understand this restriction, why a user can run a macro from doc1.dotm, but word don't let to view the code. ("blocked project" warning)
Thanks!
__________________
Backup your original file before doing any modification.
Reply With Quote
  #4  
Old 04-13-2018, 03:03 PM
macropod's Avatar
macropod macropod is offline View/edit macro in DOTM file. Windows 7 64bit View/edit macro in DOTM file. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless the project is password protected, you can view it from any document attached to the template; if it is password protected, you can't view it at all without supplying the password.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-13-2018, 09:39 PM
Guessed's Avatar
Guessed Guessed is offline View/edit macro in DOTM file. Windows 10 View/edit macro in DOTM file. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The vba code contained in addins is not available for viewing or editing UNLESS the addin is explicitly opened. If you want to edit the code, open the addin directly - it doesn't matter if it is already loaded.

Note that if the template is VBA password protected this still won't give you access to the code.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 04-14-2018, 04:33 AM
eduzs eduzs is offline View/edit macro in DOTM file. Windows 10 View/edit macro in DOTM file. Office 2010 32bit
Expert
View/edit macro in DOTM file.
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

That's what I was thinking. The only way is to open the dotm file itself.
Thanks.
__________________
Backup your original file before doing any modification.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
View/edit macro in DOTM file. Have to click View > Edit Document every time I open my file? lolaboona Word 1 02-12-2015 04:26 PM
View/edit macro in DOTM file. macro not saved in normal.dotm silveredge8181 Word 8 06-09-2014 07:58 PM
View/edit macro in DOTM file. Open Quickpart file normalemail.dotm - edit multiple building blocks rollno Word 7 02-24-2014 04:29 PM
View/edit macro in DOTM file. Editing .dotm/.dotx/dot file martinlest Word 9 10-09-2013 01:57 PM
View/edit macro in DOTM file. Adding macro to normal.dotm programmatically etippelt Word VBA 6 04-08-2013 05:55 PM

Other Forums: Access Forums

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


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