Office Software Thread, Excel - Read Only in Technical; I have been asked today if it is possible to make Excel display an option/change colour/send an alarm if you ...
5th October 2009, 09:15 PM #1
Excel - Read Only
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)
IDG Tech News
5th October 2009, 09:18 PM #2
Perhaps I am misunderstanding, but Excel does display a warning if you try to save an edited read only document doesn't it?
5th October 2009, 09:47 PM #3
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.
5th October 2009, 09:55 PM #4
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
<do some stuff here, eg, turn the top row or something>
By russdev in forum Jokes/Interweb Things
Last Post: 20th April 2009, 08:41 PM
By DrPerceptron in forum General Chat
Last Post: 6th December 2008, 11:46 PM
By GrumbleDook in forum Thin Client and Virtual Machines
Last Post: 15th March 2007, 12:03 AM
By Lee_K_81 in forum Courses and Training
Last Post: 15th January 2007, 02:02 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)