A
a.fawcett
Hi guys,
I have just started a new job and have created macro's for the staff to
simply click a button (ie "Letterhead") and a read only of the
precedent (ie the letterhead) appears. This is working fantastically
EXCEPT:
If you try and open an old document that is a letterhead (regardless of
whether it is read only or template) it prompts you to either click
"read only" or to enter the password to edit that document.
I only want the password function to the precedents themselves (in
order to prevent them from being edited accidently). I don't want the
password function when you try to call up a previously saved document.
Here is a sample of the current macro for our letterhead:
---------------------------------------------------------------------------------------------------------------------------------------
Sub Letterhead()
'
' Letterhead Macro
' Macro recorded 17/07/2006 by AFawcett
'
Documents.Open FileName:="M:\BL Templates\blletterhead.dot",
ConfirmConversions:=False, _
ReadOnly:=True, AddToRecentFiles:=False, PasswordDocument:="",
_
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="",
_
WritePasswordTemplate:="", Format:=wdOpenFormatAuto,
XMLTransform:=""
Selection.MoveRight Unit:=wdCharacter, Count:=16
Selection.MoveLeft Unit:=wdCharacter, Count:=3
Selection.MoveRight Unit:=wdCharacter, Count:=1, Extend:=wdExtend
---------------------------------------------------------------------------------------------------------------------------------------
Does anyone know how to stop the "read only or enter password" box
prompting up every time you try and open and old document?
Any advice would be appreciated as I am a novice and have run out of
idea.
Many thanks,
Adam
I have just started a new job and have created macro's for the staff to
simply click a button (ie "Letterhead") and a read only of the
precedent (ie the letterhead) appears. This is working fantastically
EXCEPT:
If you try and open an old document that is a letterhead (regardless of
whether it is read only or template) it prompts you to either click
"read only" or to enter the password to edit that document.
I only want the password function to the precedents themselves (in
order to prevent them from being edited accidently). I don't want the
password function when you try to call up a previously saved document.
Here is a sample of the current macro for our letterhead:
---------------------------------------------------------------------------------------------------------------------------------------
Sub Letterhead()
'
' Letterhead Macro
' Macro recorded 17/07/2006 by AFawcett
'
Documents.Open FileName:="M:\BL Templates\blletterhead.dot",
ConfirmConversions:=False, _
ReadOnly:=True, AddToRecentFiles:=False, PasswordDocument:="",
_
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="",
_
WritePasswordTemplate:="", Format:=wdOpenFormatAuto,
XMLTransform:=""
Selection.MoveRight Unit:=wdCharacter, Count:=16
Selection.MoveLeft Unit:=wdCharacter, Count:=3
Selection.MoveRight Unit:=wdCharacter, Count:=1, Extend:=wdExtend
---------------------------------------------------------------------------------------------------------------------------------------
Does anyone know how to stop the "read only or enter password" box
prompting up every time you try and open and old document?
Any advice would be appreciated as I am a novice and have run out of
idea.
Many thanks,
Adam