Print Preview Protected Embedded Chart?

[Ken]

Excel 2000 ... I have protected Tab Sheets with appropiate
cells unlocked. These same sheets have embedded charts.
I wish no changes to the data or charts other than where I
have unlocked cells. I want capability to Print Preview
chart without allowing any other changes to take place.

Above said ... I can unlock the object (the chart), but
this appears to allow the chart to be changed when sheet
is protected.

I just want cabability to Print Preview Chart without
allowing any other changes to take place. Is there a
way? ... Thanks ... Kha

 

[Jon Peltier]

Hi Ken -

I don't think you can do this from the Excel user interface, but using
VBA, these simple macros protect and unprotect the data and formatting
of a chart, but allow print preview.

Sub ProtectChart()
With ActiveChart
.ProtectData = True
.ProtectFormatting = True
End With
End Sub

Sub UnProtectChart()
With ActiveChart
.ProtectData = False
.ProtectFormatting = False
End With
End Sub

- Jon