password protect
 

is there a way to have an EXCEL workbook and only allow
it to be opened by entering a password? I would like to
send a workbook and only allow someone who has the
password to open and view the workbook.
thanks

Frank, do a save as, then under tools, general options, enter a password to
open
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"frank" wrote in message
...
is there a way to have an EXCEL workbook and only allow
it to be opened by entering a password? I would like to
send a workbook and only allow someone who has the
password to open and view the workbook.
thanks

frank

FileSave AsToolsGeneral OptionsPassword to open.


Gord Dibben Excel MVP

On Mon, 21 Mar 2005 08:29:51 -0800, "frank" wrote:

is there a way to have an EXCEL workbook and only allow
it to be opened by entering a password? I would like to
send a workbook and only allow someone who has the
password to open and view the workbook.
thanks