Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2023, 07:07 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

Quote:
Originally Posted by elaineAda View Post
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?
Basically it is to unprotect a password protected document, then re protect upon closing. Appreciate help on this.
Reply With Quote
Reply



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 08:33 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