Chart titles

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Neil,
In XL2002 and XL2003 you can specify what items on a worksheet the user can
access. Normally Objects are not selected. SO if I protect a worksheet
making no changes in the dialog box then I cannot select a chart, so I
cannot delete it.

Title: Before you protect the worksheet:
Give the chart some dummy title; click on this title; type = in the Formula
Bar and click on a cell.
Format this cell to unlock it (on Protection tab), if cell is to be on
protected sheet
Now protect worksheet
User can change the content of the cell and the title in chart changes.

best wishes
Bernard
www.stfx.ca/people/bliengme
 
Back
Top