rad Posted October 5, 2009 Posted October 5, 2009 I have been asked today if it is possible to make Excel display an option/change colour/send an alarm if you are trying to edit an excel document you have opened as a read only. Currently opened with Office 03 but if 07 has an option they will upgrade. (or any other suggestions welcome)
sparkeh Posted October 5, 2009 Posted October 5, 2009 Perhaps I am misunderstanding, but Excel does display a warning if you try to save an edited read only document doesn't it?
rad Posted October 5, 2009 Author Posted October 5, 2009 Your right but the office staff view a document all day either as read only or open the doc as per usual and then leave it open, but they want to know if there is a way it can show as a different colour/warning message when they are in it as read only. They all work in same office.
sparkeh Posted October 5, 2009 Posted October 5, 2009 Oh right ok, yeah this is easy. There is a vba property to find this out, been a while since I used vba but you could check the following on opening: If ActiveWorkbook.ReadOnly Then End If
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now