Determine Workbook Mode

's Computer Specifications

The first line in this if-statement is incorrect. What would be the correct
syntax?

If ActiveWorkbook.Mode <> xlReadOnly Then
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
End If

's Computer Specifications

If Not ActiveWorkbook.ReadOnly Then
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
End If

Mike H. wrote:
> The first line in this if-statement is incorrect. What would be the correct
> syntax?
>
> If ActiveWorkbook.Mode <> xlReadOnly Then
> ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
> End If

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I determine if a workbook is a template?	=?Utf-8?B?Q2xheW1hbg==?=	Microsoft Excel Programming	2	6th Jul 2007 06:08 PM
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened	Ronald Dodge	Microsoft Excel Programming	13	18th May 2007 02:24 PM
Re: How can I determine who has workbook open?	rjamison	Microsoft Excel Programming	0	14th Jun 2005 12:14 AM
How can I determine if the app is running in Debug mode or Release mode?	Henry Padilla	Microsoft VB .NET	4	5th May 2005 05:36 PM
Determine if a workbook is shared	=?Utf-8?B?cXVhcnR6?=	Microsoft Excel Programming	3	2nd Mar 2004 10:23 PM