Prev: opening .xls in 2007 version
Next: Excel 2007: Selection windows slows down when highlighting cells
From: Gixxer750 on 12 Feb 2010 13:51
Hi

I have created a spreadsheet that does calculations in the background, my
question is how do I apply a password BEFORE the user gets to see the main
sheet. e.g when they open the spreadsheet they are automatically asked for
the password before anything else.

Any help would be greatly appreciated.

Many thanks
From: KC hotmail com> kcrippstein on 12 Feb 2010 14:01
In Excel 2003, go to Tools > Options, select the Security tab, and specify a
password needed to open the workbook.

In Excel 2007, it's way more difficult. Go to the Office button > Save As,
then in the Save As dialogue you'll see a "Tools" button in the bottom left
corner. Select it and choose "General Options" to see a pop-up dialogue
which asks you what password you'd like to require to open the file.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Gixxer750" wrote:

> Hi
>
> I have created a spreadsheet that does calculations in the background, my
> question is how do I apply a password BEFORE the user gets to see the main
> sheet. e.g when they open the spreadsheet they are automatically asked for
> the password before anything else.
>
> Any help would be greatly appreciated.
>
> Many thanks
 | 
Pages: 1
Prev: opening .xls in 2007 version
Next: Excel 2007: Selection windows slows down when highlighting cells