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 ToolsProtectionProtect Workbook... but this failed to protect the
workbook.

I tried ToolsProtectionProtect 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