Re: Avoid Delete Formulas

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/11/04


Date: Thu, 11 Mar 2004 11:18:17 +0100

Hi
though this is in general possible this would require (depending on the
number of formulas you use and how different they are) a lot of coding
(and hardcoding the formulas into the code or storing themn in static
arrays)

I rellay would suggest using the worksheet protection or is there a
business reason why you can't use protection?

--
Regards
Frank Kabel
Frankfurt, Germany
> I don't want to protect worksheet. But when a formula in the sheet in
> any cell will be deleted or changed then can I undo the action by
> using sheetchange event
>
>
> ---
> Message posted from http://www.ExcelForum.com/


Relevant Pages

  • Re: Protection indicator
    ... Worksheet protection? ... Depending on what you choose to protect, you might be able to just look at the ... Bold Icon and tell. ... Does anyone know if there is an indicator that shows if Protection is ...
    (microsoft.public.excel.misc)
  • Re: Security - protect code?
    ... For "casual" protection against the basically honest but curious, ... checking the Lock project from viewingcheckbox and entering a password ... > view the coding. ... > would like the user to do is use the sheet, and i would like to be the ...
    (microsoft.public.excel)
  • Re: Macro ro update links from protected workbooks
    ... the worksheet protection that prevents the workbook to be edited but rather ... the protection that prevents other user from opening the files itself. ... > I have a workbook.open in my code and the updatelink is set to true. ...
    (microsoft.public.excel)
  • Re: Clipboard turn empty running worksheet.unprotect - workaround ?
    ... I think your best approach is to turn on worksheet protection with the ... UserinterfaceOnly parameter set to true. ... Sub CopyCell() ...
    (microsoft.public.excel.programming)
  • Re: Seeking help for total worksheet protection
    ... Another problem we're seeing with worksheet protection is that if the ... >> The VBA widgets each have a Locked property, ... > implementing an Excel Viewer window inside our application. ...
    (microsoft.public.excel)