+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1
    rad
    rad is offline
    rad's Avatar
    Join Date
    Jan 2009
    Location
    Middlesex
    Posts
    2,529
    Thank Post
    339
    Thanked 319 Times in 242 Posts
    Rep Power
    112

    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)

  2. #2

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    7,019
    Thank Post
    1,365
    Thanked 1,771 Times in 1,193 Posts
    Blog Entries
    22
    Rep Power
    530
    Perhaps I am misunderstanding, but Excel does display a warning if you try to save an edited read only document doesn't it?

  3. #3
    rad
    rad is offline
    rad's Avatar
    Join Date
    Jan 2009
    Location
    Middlesex
    Posts
    2,529
    Thank Post
    339
    Thanked 319 Times in 242 Posts
    Rep Power
    112
    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.

  4. #4

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    7,019
    Thank Post
    1,365
    Thanked 1,771 Times in 1,193 Posts
    Blog Entries
    22
    Rep Power
    530
    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>
    End If

SHARE:
+ Post New Thread

Similar Threads

  1. [News] Before posting please read.
    By russdev in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 20th April 2009, 07:41 PM
  2. Headlines you have to read twice...
    By DrPerceptron in forum General Chat
    Replies: 4
    Last Post: 6th December 2008, 10:46 PM
  3. Read all about it!!!
    By GrumbleDook in forum Thin Client and Virtual Machines
    Replies: 4
    Last Post: 14th March 2007, 11:03 PM
  4. Do the course or just read the book?
    By Lee_K_81 in forum Courses and Training
    Replies: 4
    Last Post: 15th January 2007, 01:02 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •