Protecting a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top