Why not just protect the sheet with a password. Once done, none of the cells can be edited at all, except for cells you specifically remove protection from prior to protecting the whole sheet.
Why not just protect the sheet with a password. Once done, none of the cells can be edited at all, except for cells you specifically remove protection from prior to protecting the whole sheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the response, JBeaucaire!
Actually, I need to do this for perticular cells.
Moreover , this is just a case, so as to get the programming way to understand.
There are other things need to be done for some other cell like -
To pop up a window saying "Please make same changes in so-n-so file as well!" after the cell value is changed.
I hope I'm able to state what exactly I want.
If it's not clear , plz let me know.
Thanks.
- Shil
Agreed n sorry for that.
I just considered only one scenario.
Plz refer to the redefined issue.
Thanks.
These are the rows having 1st column (column header) as 'Group1' or 'Group2' and first row (row header) as 'Expenses' or 'Savings'.
Oh.. just came across some stuff on net.
Yes, i can specify the cells like B12, C12
Is it possible to pop up window like 'Please make same changes in so-n-so file as well!' once the B12, C12 cells are changed?
Thanks in adavnace for the help.
JBeaucaire is the best answer, here is a code that will do what you want
![]()
Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "Please do not Change this" Target.Select End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks