Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Locked cell Change Message

I have a spread sheet that i use that has many formula's on it.
I have the cells with formula's set to Locked, so that they are not
accidently deleted or modified by a user.

But i have found occasionally, somehow, a cell that is Locked and contains a
formula, is deleted.

There is times when macro's are run to Protect/Unprotect the sheet, but
think a user may have unprotected the sheet manually somehow, and accidently
deleted the formula.

My question is, Is it possible to have a Prompt, or Message Box come up to
Indicate that a Locked Cell that contained a Formula has been modified?

If so how can i do this?
Would it ben in the Worksheet_Change event?

Corey....


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show a customised message when a trying to edit a locked cell Emily Ladywell Excel Worksheet Functions 1 May 21st 09 06:03 PM
change locked cell if Vincent Excel Discussion (Misc queries) 2 August 22nd 07 02:12 PM
Relacing default Excel message box when user attempts to change locked cell on protected sheet. Chrisso Excel Programming 2 March 19th 07 04:55 PM
How do I add a balloon message to a locked cell kden01 Excel Discussion (Misc queries) 2 January 28th 05 06:49 PM
Customizing the Locked Cell Warning Message Box Jim Cone Excel Programming 0 June 21st 04 06:26 PM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"