Protecting a workbook

[Guest]

Hello

I have created an excel workbook which has 4 worksheets. There are a number
if charts in the first worksheet that are driven by data in worksheets 2 to
4.

I have written some quite extensive VBA code to drive the charts.

I want to protect the workbook so that others can use the workbook but not
make amendments to the workbook.

I tried Tools>Protection>Protect Workbook... but this failed to protect the
workbook.

I tried Tools>Protection>Protect Worksheet...which worked. BUT when I
pressed some of the buttons on the worksheet to activate the VBA code then
the macros failed to work correctly even though they had been fine.

So is there a reason why protecting a worksheet would interfere with VBA
code...or is it just a bug within Excel...

Thanks for any insights that anybody may offer...


Alex

 

[Beto]

Alex,

In Excel 2003...

Select "Save as" from file menu
Select "Tools" at right top area from "Save As" screen
Select "General Options"
Select "Password to Open" - assign the password to open the file, then
retype
(User must know the password to open the file)
Select "Password to Modify" - assign the password to open the file,
then retype (User must know the password to modify the file)

Let me know if you need further assistant
Roberto - (e-mail address removed)