Questions

[Neil]

Please can anyone help me with a couple of questions I have about am Excel XP
spreadsheet I have devised to pass out to other people.

1. I have a graphic on the spreadsheet which I want to make 'delete proof' I
have used cell protection and a pass work to protect the sheet, but the
graphic is still removeable, is there a cure for this?

2. On the sheet is a graph, the graph itself needs to be protected, but the
titles could do with being editable, or linkable to another cell (in a
seperate data sheet) that the user could edit to change the titles.

I'm not a stranger to VBA, so if the solution to either of these problems
involved some coding, then I'm comfotable with it, I just need pointing in
the right directon

Thanks in advance

Neil

 

[PeterAtherton]

Neil

Delete the title box on your chart and replace it with a textbox from the
Control Tools, (View, Toolsboxes, Control Toolbox) and draw a textbox from
the options.

Doubleclick on the textbox to open the VB editor and choose View Properties
and link the cell in the properties options.

Then drag the text box on to the chart and protect the sheet normally


Peter