I need to open a workbook and have it ask the user for a password. If they
know the password then they can use the workbook, however if they do not know
the password then they can only view what the workbook has in it.
The workbook has a lot of code in it and creates sheets automatically but
there will only be a couple of users that will actually enter data, the rest
will just need to view the information entered without the ability to make
any changes. Is there a way to do this when the workbook opens?

XL2003: FileSaveAsToolsMenuGeneralOptions
Allows you to enter a password to open and, optionally, a password to modify
(i.e., if opened, it can't be saved unless the modify password is known).

However, this may not do exactly what you wish: your code will still run,
adding sheets that the user won't be able to save.

Consider asking the user for a password when the workbook opens. Don't let
your code run and cancel Workbook_Save if that password is not supplied.

There are also methods to password protect individual worksheet elements:
ToolsProtection

HTH,

"jnf40" wrote in message
...
I need to open a workbook and have it ask the user for a password. If they
know the password then they can use the workbook, however if they do not
know
the password then they can only view what the workbook has in it.
The workbook has a lot of code in it and creates sheets automatically but
there will only be a couple of users that will actually enter data, the
rest
will just need to view the information entered without the ability to make
any changes. Is there a way to do this when the workbook opens?

Why don't you just use excells own password protection, Save your
workbook using "Save As"
any name but before you do click on the dropdown with the titled Tools
in the save as dialog box,
choose "general options" click the read only recommend and add a
password to modify!

Now when they try to open the workbook they will need a password to
change anything or
they can view it "Read Only"

Regards,
Simon


--
Simon Lloyd