Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Specifies whether formatting restrictions are enforced for a protected document. Specifies whether to use Information Rights Management (IRM) when protecting the document from changes. ![]() There are several reasons why a file opens in Protected View: The file was opened from an Internet location - When you see the message in Protected View that says 'Be careful - files from the Internet can contain viruses. Click Insert > Module and paste the following code into the code window: Sub AddRow () ActiveSheet.Unprotect Password:'secret' Range ('A1').End (xlDown). AlwaysInsert:False ActiveSheet. If supplied, the password to be able to edit the document, or to change or remove protection. Protected View is a read-only mode where most editing functions are disabled. If Type is not wdAllowOnlyFormFields, NoReset is ignored. Starting from the first empty paragraph mark, hold down shift and cursor down to the second empty paragraph, highlighting the two paragraphs and every thing in between. Parameters Nameįalse to reset form fields to their default values True to retain the current form field values if the document is protected. ![]() ![]() Protect ( Type, NoReset, Password, UseIRM, EnforceStyleLock)Įxpression A variable that represents a Document object. Protects the specified document from unauthorized changes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |