![]() |
#1
|
|||
|
|||
![]()
Hi All,
I'm from the Netherlands. I have a word docm file. I have set it's property to read only with windows explorer. When I open the file with Word 2016 it is by protected for editing wich I understand based on my setting in windows explorer. If done this to prevent the file for overwriting by a user when they press Ctrl+S. What I what is to run a macro attached to a form which I show when the document is activated to enable editing. Now I have to do this by hand (see attachment, click "Beeld", click "Document bewerken". I can't find how to activate the command bar (Beeld) at the top and select the option to enable editing (Document bewerken). See the attachment. It's in Ducth ![]() Hopefully someone can help me. Thnxs to you all! |
#2
|
|||
|
|||
![]()
The first thing you need to do is use the record feature to record the steps that you want your macro to take. Once you have that, create a userform with a couple buttons to put that code with.
Lastly, once you have the userform created, create a new sub called AutoOpen(). In that sub put "Userform1.Show" (or whatever your userforms name is). Whenever that document is opened, that userform will initiate. |
#3
|
||||
|
||||
![]()
A macro can't change the Windows Explorer read-only attribute of an opened file. If you don't want users to edit the files, you should use Word's own read-only recommended option (see under Save As>Tools>General). Alternatively - and perhaps preferably in this case - save the document as a Word Template, which means the users will actually be creating a new document each time they double-click on the file.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
![]()
Hi macropod/dwirony.
The solution mentioned by macropod seems to be working just fine for me. I was thinking much to complicated ![]() ![]() Greets! |
![]() |
Tags |
macro, office 2016, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
as to activate a macro without operator input ? | gianca53 | Excel Programming | 0 | 02-02-2017 09:09 AM |
Was hoping to use a Macro on the attached form, but... | brians34 | Word VBA | 3 | 09-15-2015 11:56 AM |
![]() |
srinidhi.mv88 | Excel Programming | 5 | 05-19-2015 12:06 AM |
macro used to activate shortcut keys | hudsontucker13 | PowerPoint | 1 | 12-14-2013 09:47 AM |
Run Macro & Activate shape | ibrahimaa | Excel Programming | 1 | 01-21-2012 02:14 AM |