[dba-Tech] Excel - skip running code?

Right you are - and with a password protected spreadsheet it seems you have
to press shift *after* you enter the password! 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: 29 April 2008 15:39
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Excel - skip running code?

I believe shift is supposed to work in Excel too.

That's what Excel Help says at least.

GK

On Tue, Apr 29, 2008 at 8:48 AM,  <rosalyn.clarke at barclays.com> wrote:
> Hi all
>
>  I have been given an excel spreadsheet that I'm told needs work doing 
> on it,  but when I open it, it prompts me for the password, which I 
> enter, then it  immediately closes itself. I can tell it's opened ok 
> because it's there in my  recently used files list.
>
>  I don't know what version of Excel it was created with - I am running 
> 2003. I  know it contains code - is there any way to open the file 
> without any code  running, in case it is the code that's causing it to 
> close? Something simple  like the Shift key trick in Access?
>
>  TIA
>
>  Roz
>
>  This e-mail and any attachments are confidential and intended solely for
the addressee and may also be privileged or exempt from disclosure under
applicable law. If you are not the addressee, or have received this e-mail in
error, please notify the sender immediately, delete it from your system and
do not copy, disclose or otherwise act upon any part of this e-mail or its
attachments.
>
>  Internet communications are not guaranteed to be secure or virus-free.
>  The Barclays Group does not accept responsibility for any loss arising
from unauthorised access to, or interference with, any Internet
communications by any third party, or from the transmission of any viruses.
Replies to this e-mail may be monitored by the Barclays Group for operational
or business reasons.
>
>  Any opinion or other information in this e-mail or its attachments that
does not relate to the business of the Barclays Group is personal to the
sender and is not given or endorsed by the Barclays Group.
>
>  Barclays Bank PLC.Registered in England and Wales (registered no.
1026167).
>  Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.
>
>  Barclays Bank PLC is authorised and regulated by the Financial Services
Authority.
>
>  _______________________________________________
>  dba-Tech mailing list
>  dba-Tech at databaseadvisors.com
>  http://databaseadvisors.com/mailman/listinfo/dba-tech
>  Website: http://www.databaseadvisors.com
>



--
Gary Kjos
garykjos at gmail.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments.

Internet communications are not guaranteed to be secure or virus-free.
The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons.

Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group.

Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.

Barclays Bank PLC is authorised and regulated by the Financial Services Authority.