Hi folks, i'm trying to open a word doc from Excel as Read Only and apply Track changes (or TrackRevisions as it shows in vba) - I can do either action independently no problem but I cannot do both and it seems to be due to Word auto opening in 'Read Mode' so have been trying to find a way to open in Print mode from Excel but can't find anything.
It will open the file in Read Only and then error at the with statement but if I choose print layout on document I can manually apply track changes no problem.
The reason is that I do not want the main file(s) accidently amended so the ide is they can open the main file but then have to save a local copy with track changes which needs to be sent to another team for upload. The Read Only permission is applied on folder permissions anyway but there has been occasion where staff have been set up with read / write access accidently so id rather be able to do this.
Bookmarks