RE: Protected excel

  • From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Fri, 5 Nov 2004 12:38:48 -0000

Mark,

Excel has a feature called "protection" which allows you to lock a
spreadsheet so that it cannot be altered. I assume this is what you mean
when you refer to a spreadsheet being locked.

I'm sighted and I don't see any symbol to indicate when a spreadsheet is
protected.  However, some of the icons on the toolbars are greyed out to
indicate they are unavailable.

One way you could infer whether an Excel spreadsheet is protected
against being changed is to browse the menus; you'll find all the ones
to do with changing things are unavailable. For instance, almost
everything on the Format menu is unavailable.

A specific way to tell if it is protected is to open the Tools menu and
go into the Protection submenu.  If the first item is called "Protect
Sheet" then it is currently unprotected; if it is called "Unprotect
Sheet" then it is currently protected.

Hope this helps,

---
Steve Griffiths,
IT Trainer, Access Technology Support Unit
Royal National Institute of the Blind
105 Judd Street
London WC1H 9NE
Tel: 020 7391 2232
Email: steve.griffiths@xxxxxxxxxxx
Fax: 020 7383 2034

-- 
DISCLAIMER:

NOTICE: The information contained in this email and any attachments is 
confidential and may be privileged.  If you are not the intended 
recipient you should not use, disclose, distribute or copy any of the 
content of it or of any attachment; you are requested to notify the 
sender immediately of your receipt of the email and then to delete it 
and any attachments from your system.

RNIB endeavours to ensure that emails and any attachments generated by
its staff are free from viruses or other contaminants.  However, it 
cannot accept any responsibility for any  such which are transmitted.
We therefore recommend you scan all attachments.

Please note that the statements and views expressed in this email and 
any attachments are those of the author and do not necessarily represent
those of RNIB.

RNIB Registered Charity Number: 226227

Website: http://www.rnib.org.uk



--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: