Print protected excel graphs

[ken1010]

Hi all,

I have created a spreadsheet and protected the sheet completely. However, recently one of the user's wishes to print-out one of the graph but as the spreadsheet is protected they can't do that. I've used "edit objects" but that dosen't seem to work as I wish.
Does anyone know of a macro and VB code I could use?

Thanks,
Ken.

[6StringJazzer]

I created a worksheet with a chart on the same sheet, then protected the worksheet, and no problems printing the worksheet, including the chart. However, I could not select the chart. By checking Edit Objects while protecting, I could then select the chart to print only the chart (although that also allows me to make any changes I want to the chart).

I was also able to move the chart to a Chart Sheet, protect the Chart Sheet, then print the chart from there.

Can you clarify what your user wants to do, and what the problem is? It might be helpful for you to attach your file.