LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Excel 2010 is not acting the same with ReadOnly...

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez[_2_] Excel Worksheet Functions 2 January 26th 10 06:58 PM
Excel WB opened from Sharepoint as ReadOnly, ReadONLY for WB = FAL Barb Reinhardt Excel Programming 0 January 19th 10 10:44 PM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 Darrell[_2_] Excel Programming 0 January 12th 10 08:53 PM
How do I use VC++6.0 to protect a excel file to readonly gowinder Excel Programming 2 September 22nd 05 02:18 AM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"