sounds stupid, but I have a deletion problem

  • Thread starter Thread starter unco_dunco
  • Start date Start date
U

unco_dunco

I have a worksheet, that was made by someone else and it has a button o
the worksheet that says "Clear Sheet" when you press the button, i
clears certain cells that are data enterable, but leaves the cells tha
have formulas in it.

Problem is, I want to create a cell with another formula in it, but
can't seem to protect it from being deleted.

Is there a way that I can find out how to enter this cell in th
protection.

The overall sheet is not protected, as I have already removed th
password, but it this weird button that I can't find the commands to


Your help is greatly appreciated
 
It's a macro, press Alt + F11 and look in the left project pane for a
module,
or if the button is from the control toolbox you need to go in design mode
and right click
and select view code or once again do Alt + F11 and double click the sheet
name where
the button is in the same left project pane

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top