Excel 2010 is not acting the same with ReadOnly...

S

SS

Hi,
I have this code to determine if the file was opened as read only, and
then stop the lengthy macro before it runs, if it is read only.
If ActiveWorkbook.ReadOnly Then
MsgBox "It appears that the file was opened as read-only."
& Chr(10) & Chr(10) _
& "Please check out the file first, or open for editing
(Windows 7)."
Exit Sub

End If
(code continues)

However, when i run this on Excel 2010, with the file opened as read
only, the statement above does not return the message box warning. It
just continues past it.

I guess my question is, has something changed in 2010. Works fine in
2003 and before.

Note, I am using this file from a Sharepoint site.

Thanks for any help,
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate pst, or is it? 1
Name of file opened, being viewed 2
Sub projects added as read only in Master file which are saved on sharepoint 1
Read Only now different 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Make "File in use" message appear when 2 people open the a shared document in the same time 3
Working outlook via vba code with xlsx - error 0
Embedded Excel into Word with Tables 0

Top