Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-29-2023, 03:00 AM
elaineAda elaineAda is offline How to make users enable macro before opening the file? Windows XP How to make users enable macro before opening the file? Office 2010
Novice
How to make users enable macro before opening the file?
 
Join Date: Mar 2019
Posts: 25
elaineAda is on a distinguished road
Default

Hi BrianHoard
It didnt seem to work.
I have a turn around solution, it is to password protect the file, and user can only edit the file when user click on 'enable content.'
But the macro that i wrote cannot work perfectly.
Error message encountered when user save the file, and then close the file without saving the file. When user exit the file like that, the file was not save and became password unprotected.
When user try to access the file the next round, there is error message.
Is there anyway to go about this?
Attached Files
File Type: docm sample text 1 macro1.docm (27.1 KB, 4 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Autorun macro when opening the file Tom cheeseburger PowerPoint 2 07-07-2021 05:42 PM
How to make users enable macro before opening the file? How to automatically enable the macros upon opening a file with macros? laurieli Office 7 01-17-2016 08:56 AM
How to automatically enable macros upon opening the Word? laurieli Word VBA 2 12-22-2015 02:46 PM
How to make users enable macro before opening the file? Automatically make .dotm file available to all users on network donaldadams1951 Word 2 02-26-2014 10:47 PM
How to make users enable macro before opening the file? Prompt a macro to run when opening a specific file type gmanword Word VBA 5 11-30-2013 02:55 PM

Other Forums: Access Forums

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