+ 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,507
    Thank Post
    337
    Thanked 310 Times in 238 Posts
    Rep Power
    110

    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
    6,809
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    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,507
    Thank Post
    337
    Thanked 310 Times in 238 Posts
    Rep Power
    110
    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
    6,809
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    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
  •