Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2025, 09:02 AM
MartinGM MartinGM is offline OneDrive issue ? Or is it Word ? Windows 11 OneDrive issue ? Or is it Word ? Office 2021
Competent Performer
OneDrive issue ? Or is it Word ?
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default OneDrive issue ? Or is it Word ?

Ths isn't a VBA question !

I put an "on open" macro into my document - that works just fine.


Except that as it is now a macro-enabled Word file OneDrive refuses to let it be Autosaved (despite the constant nag to Autosave my documents).

Aaaargh

Is there any way around this arbitrary maze of permissions ?

I just would lke Autosave and a macro working in the same document.
Reply With Quote
  #2  
Old 09-11-2025, 07:26 PM
Charles Kenyon Charles Kenyon is offline OneDrive issue ? Or is it Word ? Windows 11 OneDrive issue ? Or is it Word ? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,536
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

Most macros should be stored in templates, not documents.
I have no trouble with macro-enabled templates stored on OneDrive, so long as I use their synced counterparts from my hard drive.
I avoid AutoSave. It does not work reliably and only works for documents/templates saved or synced to OneDrive/SharePoint.
Reply With Quote
  #3  
Old 09-13-2025, 01:47 AM
MartinGM MartinGM is offline OneDrive issue ? Or is it Word ? Windows 11 OneDrive issue ? Or is it Word ? Office 2021
Competent Performer
OneDrive issue ? Or is it Word ?
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default

Thanks Charles
So a question if I may - how could I get an on_open macro to function in a specific document by using a macro-enabled template ? I don't understand how to do that.
Reply With Quote
  #4  
Old 09-13-2025, 04:52 AM
chrisjj chrisjj is offline OneDrive issue ? Or is it Word ? Windows 7 64bit OneDrive issue ? Or is it Word ? Office 97-2003
Competent Performer
 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default

Quote:
Originally Posted by MartinGM View Post
Thanks Charles
So a question if I may - how could I get an on_open macro to function in a specific document by using a macro-enabled template ? I don't understand how to do that.
Nor do I. AFAICT it is impossible.

Sorry I can't suggest a solution.
Reply With Quote
  #5  
Old 09-13-2025, 05:52 AM
Charles Kenyon Charles Kenyon is offline OneDrive issue ? Or is it Word ? Windows 11 OneDrive issue ? Or is it Word ? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,536
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 MartinGM View Post
Thanks Charles
So a question if I may - how could I get an on_open macro to function in a specific document by using a macro-enabled template ? I don't understand how to do that.
Store the AutoOpen macro in the template on which the document is based. Use that template for documents where you want this behavior.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Speed Issue: Onedrive collaboration or field codes irmua77 Word 4 10-01-2022 06:19 AM
Onedrive issue=Please help! frankluke Office 1 09-30-2022 03:08 PM
OneDrive issue Fieldmouse48 Windows 0 12-07-2020 01:47 PM
Word-OneDrive-Excel link not working when Word file re-opens Prakash-Gautam Word 0 05-02-2019 07:35 PM
Issue opening OneNote folders from OneDrive Oillybob OneNote 0 04-11-2017 08:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 AM.


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