Spreadsheet Security

G

Gixxer750

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
 
K

KC hotmail com>

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top