Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
Excel WB opened from Sharepoint as ReadOnly, ReadONLY for WB = FAL | Excel Programming | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming | |||
How do I use VC++6.0 to protect a excel file to readonly | Excel Programming |