Is it possible to stop people opening a workbook in read only format?

I have a document which when used, prints individually numbered labels, and
saves the information in an archive. Instances have occurred where reference
has been made to a certain label number, bu it relates to different
information than what he archive says. All because somebocy produced the
label in read only mode, therefore not saving the information in the archive.

Saved from a previous post.

How about closing the workbook if it's opened readonly--and this'll only work if
macros are enabled!

Option Explicit
Sub auto_open()

With ThisWorkbook
If .ReadOnly = True Then
MsgBox "not available in readonly mode!"
.Close savechanges:=False
End If
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Irvine S Russell wrote:

Is it possible to stop people opening a workbook in read only format?

I have a document which when used, prints individually numbered labels, and
saves the information in an archive. Instances have occurred where reference
has been made to a certain label number, bu it relates to different
information than what he archive says. All because somebocy produced the
label in read only mode, therefore not saving the information in the archive.

--

Dave Peterson

Thank You Dave, you really are a guru! My colleagues and I have been trying
to work that out for over a week.

"Dave Peterson" wrote:

Saved from a previous post.

How about closing the workbook if it's opened readonly--and this'll only work if
macros are enabled!

Option Explicit
Sub auto_open()

With ThisWorkbook
If .ReadOnly = True Then
MsgBox "not available in readonly mode!"
.Close savechanges:=False
End If
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Irvine S Russell wrote:

Is it possible to stop people opening a workbook in read only format?

I have a document which when used, prints individually numbered labels, and
saves the information in an archive. Instances have occurred where reference
has been made to a certain label number, bu it relates to different
information than what he archive says. All because somebocy produced the
label in read only mode, therefore not saving the information in the archive.

--

Dave Peterson