Hi,

Protecting the workbook has nothing to do with sheet protection. If the
user knows the password to open the workbook, it won't affect the sheet
protection. If the user tries to open a password protected workbook they
won't even be able to see it if they don't enter a password.

You can add password protection to the sheet when you choose Tools,
Protection, Protect Sheet.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Dan" wrote:

Look at the 'protect sheet' options. In Excel 2007, it is located on the
'Review' ribbon, <Changes section You can restrict users from almost
anything by defining what they can and cannot do. You then save the workbook
with a password. If the user opens the workbook without the password, Excel
enforces the constraints you've placed.

Hope this helps. Cheers!

--Dan

"Sasikiran" wrote:

Dear,

I have a format done on excel and I need to restrict the users to insert
columns or rows in the excel sheet.

Please suggest.

Thanks