Hi, If you are abel to request from the spreadsheet author to amend the cell
protection settings to enable navigation to protected cells that would be the
best option. Alternatively if this is not possible you can insert a blank
worksheet and then refrence the protected worksheet via formulas. For example
If I have a workbook with Sheet2 being the Protected sheet and in cell A1 of
Sheet1 I type:=Sheet2!A1
And then copy and paste this formula across the required range of cells on
Sheet2 this will duplicate all the values on the protected sheet. Please note
that this basic formula will return 0 values for blank cells when using Excel's
default settings.
If you need any help on this happy to try to assist
Kind regards
Guy
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of ;
James Dundas
Sent: 30 August 2017 15:44
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Jaws and Excel question
Hello
I need to be able to navigate a spreadsheet containing several separate
worksheets. The top sheet is a read only sheet as it contains statistical
information that we are not allowed to change. The rest of the worksheets are
not read only and are working perfectly.
Jaws is not allowing me to navigate through any of the read only worksheet.
When I press f2 a message comes up that I need to unprotect the view which I
obviously can't do.
Does anyone know whether there is a way that I can navigate this read only
worksheet using jaws in the way that sighted people would be able to read it in
terms of accessing the information?
Thanks very much.
Wendy
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
This email (including any attachments) is intended only for the recipient(s)
named above. It may contain confidential or privileged information and should
not be read, copied or otherwise used by any other person unless express
permission is given. If you are not a named recipient, please contact the
sender and delete the email from your system. It is the recipient's
responsibility to ensure that appropriate measures are in place to check for
software viruses.
N�^j����b��%��(��^�i�v&�z\��Yh�)��)䙨����q�,�Jު笵��zX���+�˛��-