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

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