Embark on a journey of knowledge! Take the quiz and earn valuable credits.
Take A QuizChallenge yourself and boost your learning! Start the quiz now to earn credits.
Take A QuizUnlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.
Take A QuizPlease log in to access this content. You will be redirected to the login page shortly.
LoginSOFTWARE Computer software in Software 3 years ago
I have a template that must be protected, with "Fill in Forms" permitted. It is usually a single PAGE but on occasion must be 2 or 3 pages.
Each page must be identical to the first, including form entry fields.
I have a macro that copies the page, inserts a page break, then pastes the page on the newly CREATED 2nd page. I have a toolbar button ATTACHED to the template that works perfectly.
It works faultlessly when the template is unprotected. It does not work at all when the document is protected.
Setting Formatting Restrictions to permit Macro Text has no effect.
How do I protect this template and still have the macro run when REQUIRED?
Mogadeet
Can you modify the Macro so that it unprotects the document, runs the main part of the macro, and then re-protects the document? I don't know whether that can be done within a macro, just a thought.I gave it a try and it wouldn't let me do it. It may be lack of skill on my part, or that's something that you can't do.
Mogadeet
Quote from: soybean on June 25, 2009, 08:38:02 AM
Can you modify the Macro so that it unprotects the document, runs the main part of the macro, and then re-protects the document? I don't whether that can be done within a macro, just a thought.
Posted on 21 May 2022, this text provides information on SOFTWARE related to Computer software in Software. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Turn Your Knowledge into Earnings.
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals.