Selecting Graphs when workbook is locked

[NGUSER]

Hi.

I have a locked workbook that the user would like to copy individual graphs and copy and paste them over to power point. I can select individual cells, but can't copy a plot. I don't want to allow the user to get to the data or to the graphs.

Anyway that I can do this?

Thanks.

 

[Datsmart]

You could create a macro and assign it to a button that un-protects the worksheet, copies the chart as a picture to the clipboard, then re-protects the worksheet.

Sub CopyChart1()
    ActiveSheet.Unprotect "MyPassWord"

    ActiveSheet.ChartObjects("Chart 1").Chart.CopyPicture _
    Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture

    ActiveSheet.Protect "MyPassWord"

End Sub