Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2017, 04:13 PM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default Can I change the place of normal.dotm ?


I want to move normal.dotm (where is all my vba macros, so when I remove my flash drive noone can access my macros) to my usb flash drive as I did in excel personal.xlsb, can I do this?

How?

Thanks
Reply With Quote
  #2  
Old 05-16-2017, 05:51 PM
macropod's Avatar
macropod macropod is offline Can I change the place of normal.dotm ? Windows 7 64bit Can I change the place of normal.dotm ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Yes, you can tell Word to use a different folder for Normal.dotm, but pointing it (or Excel for Personal.xlsb) to a removable drive is not a smart thing to do, for two reasons:
1. Irrecoverable file corruption is liable to result unless you close both applications and go through the 'safe removal' process every time you want to disconnect the USB drive; and
2. the applications themselves are liable to have startup problems if the designated drive can't be found, in which case they might simply revert to the default locations with a 'vanilla' Normal.dotm for Word and no Personal.xlsb for Excel. In that case, next time you start Word or Excel, it will start up configured for the default location instead of your USB drive.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-16-2017, 06:05 PM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

I'm using my personal.xlsb in excel for years from a usb flash drive without problem, and is easy to do, sure, I backup on a daily / weekly basis.
But in relation to word, I have researched and I have seen complex answers and little objective in google, I would like to know step by step how to do.
Reply With Quote
  #4  
Old 05-16-2017, 06:43 PM
macropod's Avatar
macropod macropod is offline Can I change the place of normal.dotm ? Windows 7 64bit Can I change the place of normal.dotm ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 do a modicum more research you will also find conclusive evidence that what you propose with Normal.dotm will corrupt it (and possibly, other files on your USB drive) if you don't always close Word and go through the safe removal process before removing the drive. Still, if you don't care about the consequences, by all means go ahead - the default location is set via File|Options|Advanced>File Locations. You have been warned.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-16-2017, 06:44 PM
Charles Kenyon Charles Kenyon is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The location of the normal.dotm template is always the "User Templates Folder" set in Word advanced Options. If you set that location to be a thumb drive and it is not accessible, Word will create a new normal template elsewhere, which may mean a lot of confusion down the road. The normal template, in the course of regular use, is modified (edited) fairly frequently. Doing this while it is on a thumb drive may result in the loss of the file.

Better, IMO, would be to put your macros in a separate template, not in the normal template. Load that template as a Global Template by putting it in your Word Startup Folder. If that Startup Folder (set in Word advanced Options as well) is a thumb drive, do not edit any files directly on that drive. Do the editing on your hard drive and copy to/from the flash drive.
Reply With Quote
  #6  
Old 05-16-2017, 07:21 PM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

Thanks Macropod and Charles.
IF I create a separate template it will also be necessary to be saved in the word startup folder which is in c:\?? This will not solve my problem of saving my macros in my flash drive.
I have a policy of not leaving anything saved on my computer's hard drive at work, leaving everything on the flash drive, the only thing I could not do is with word macros/vba.
I have multiple backups of everything, flash drives, externals hdd, etc.So I'm not counting on losing my macros.
Word does not have the same option like in excel "On startup load files in this directoy" (where's personal.xlsb).
Reply With Quote
  #7  
Old 05-16-2017, 10:38 PM
gmayor's Avatar
gmayor gmayor is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can change the location of the startup folder (if your company allows it) from the same dialog used to change the user templates folder. You can also load add-in templates from the Developer tab > Templates on a per session basis.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #8  
Old 05-17-2017, 03:15 AM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

I give up of changing user template folder.
This alternative of creating a nem template "mymacros.dotm" and load with Developer tab > Templates, ok, but I can't see the code, cliclking in "Project (mymacros)" report a error (project can't be show).
Also I always need to go at Developer tab > Templates to click in the checkbox to load the template?
Reply With Quote
  #9  
Old 05-17-2017, 04:04 AM
gmayor's Avatar
gmayor gmayor is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The template has to be open in Word in order to see the code, but the macros are still available. If the template is not in the startup folder then yes, you will have to check it when you start Word - though if your normal template is not controlled, you can add code there to check it when when Word is started.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #10  
Old 05-17-2017, 05:21 AM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

Thanks.
How I can auto load the template (mymacros.dotm) within a "AutoOpen" procedure in normal.dotm?
So I will have access to the macros, but if I want to see/edit the code I will need to open the mymacros.dotm?
Reply With Quote
  #11  
Old 05-17-2017, 05:26 AM
Charles Kenyon Charles Kenyon is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by eduzs View Post
Thanks.
How I can auto load the template (mymacros.dotm) within a "AutoOpen" procedure in normal.dotm?
So I will have access to the macros, but if I want to see/edit the code I will need to open the mymacros.dotm?
If you put mymacros.dotm in your Word Startup Folder it will be loaded whenever Word is started. You can change the location of the Startup Folder, just as you can change the location of the User Templates Folder, in File > Options > Advanced. File Locations is near the bottom of the page.

The startup folder can be wherever you want. It should be included as a trusted location in the Trust Center settings.

Yes, to see the code, you will need to have the template open for editing. Again, if you are editing it, it should not be on a thumb drive.

Last edited by Charles Kenyon; 05-17-2017 at 06:37 PM.
Reply With Quote
  #12  
Old 05-17-2017, 04:15 PM
macropod's Avatar
macropod macropod is offline Can I change the place of normal.dotm ? Windows 7 64bit Can I change the place of normal.dotm ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

So much effort for something truly ill-advised!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 05-17-2017, 06:34 PM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

Yes, but as I am not MS expert, regardless of my average knowledge in VBA excel, I could not imagine that something so simple in Excel is absolutely complex in word. lol
I thought you might take easy with the beginners' difficulties and threads.
Reply With Quote
  #14  
Old 05-17-2017, 07:02 PM
macropod's Avatar
macropod macropod is offline Can I change the place of normal.dotm ? Windows 7 64bit Can I change the place of normal.dotm ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

It is not at all complex. It is simple. But how you want to use it will be a disaster. You're obviously determined to ignore what you've been told about the consequences.

If you're so concerned about others having access to 'your' code, etc. (which you've probably done little more with than lifting from various forums), why don't you just set up different user accounts for each user or have one for your self and a different one for everyone else???
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #15  
Old 05-17-2017, 07:08 PM
eduzs eduzs is offline Can I change the place of normal.dotm ? Windows 10 Can I change the place of normal.dotm ? Office 2010 32bit
Expert
Can I change the place of normal.dotm ?
 
Join Date: May 2017
Posts: 262
eduzs is on a distinguished road
Default

Thanks, I'm moving my macros to individual DOCM as possible, leaving normal.dotm as few as possible. I will not change advanced setting in word to avoid any problem. Just move some modules and userforms and a little code change. Additionally I can change from one to another computer without need to configure word vba.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I change the place of normal.dotm ? Won't load Normal.dotm rwsinky Word 2 10-09-2016 02:38 PM
Can I change the place of normal.dotm ? Normal.dotm location? gogreen Word 6 07-17-2016 09:45 AM
Can I change the place of normal.dotm ? Can't find Normal.dotm Ajeeja Word 8 08-14-2014 07:36 AM
Can I change the place of normal.dotm ? New template/New normal.dotm kenglade Word 3 12-19-2011 04:00 PM
Can I change the place of normal.dotm ? How to get to normal.dotm Aiken_Bob Word 4 05-02-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 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