G
Guest
HOW CAN I SHARE A WORKBOOK BUT REQUIRE A PASSWORD IN ORDER ANYONE TO MAKE CHANGES TO IT?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave R.
Christ.. you must be the 4th person today to ask about putting passwords on
files.
Try turning your caps lock off, going into Excel, pressing F1 to get into
the help section, and looking up "password" in the index.
files.
Try turning your caps lock off, going into Excel, pressing F1 to get into
the help section, and looking up "password" in the index.
CHANGES TO IT?BEN said:HOW CAN I SHARE A WORKBOOK BUT REQUIRE A PASSWORD IN ORDER ANYONE TO MAKE
N
Norman Harker
Hi Ben!
Typing all upper case is considered by most to be shouting and is more
difficult to read especially if you first language isn't the one used.
Two ways here. To impose password protection to the entire workbook
you could use:
File > Save As
Click Tools
General Options
put a password in the modify box
confirm
OK
This makes the workbook read only without requiring a password for
opening it. The method sequence varies slightly between versions of
Excel but it is always under the File > Save As dialog. (In 2003
there's an additional route through Tools > Options)
Alternatively, you could use:
For all sheets:
Tools > Protection > Protect Sheet
Give and confirm password
OK
Then
Tools > Options > Protect Workbook
Give and confirm password
OK
The advantage of the second approach is that you don't have to protect
against changes to the entire workbook but can allow access to
pre-formatted as unlocked cells or sheets that you have not protected.
Be aware that password protection of any sort in Excel should be
regarded as very weak and a trip to Google will reveal how easy it is
to circumvent them.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Typing all upper case is considered by most to be shouting and is more
difficult to read especially if you first language isn't the one used.
Two ways here. To impose password protection to the entire workbook
you could use:
File > Save As
Click Tools
General Options
put a password in the modify box
confirm
OK
This makes the workbook read only without requiring a password for
opening it. The method sequence varies slightly between versions of
Excel but it is always under the File > Save As dialog. (In 2003
there's an additional route through Tools > Options)
Alternatively, you could use:
For all sheets:
Tools > Protection > Protect Sheet
Give and confirm password
OK
Then
Tools > Options > Protect Workbook
Give and confirm password
OK
The advantage of the second approach is that you don't have to protect
against changes to the entire workbook but can allow access to
pre-formatted as unlocked cells or sheets that you have not protected.
Be aware that password protection of any sort in Excel should be
regarded as very weak and a trip to Google will reveal how easy it is
to circumvent them.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
MAKE CHANGES TO IT?BEN said:HOW CAN I SHARE A WORKBOOK BUT REQUIRE A PASSWORD IN ORDER ANYONE TO