Hi All,
I have a worksheet in which some cells are mandatory to be filled by the user.
I require that the sheet MUST not save untill all such mandatory fields are filled.
Kindly advice.
Hi All,
I have a worksheet in which some cells are mandatory to be filled by the user.
I require that the sheet MUST not save untill all such mandatory fields are filled.
Kindly advice.
You can use an EVENT macro in the ThisWorkbook module for this.
Please Login or Register to view this content.
Notice the technique lists the cell addresses on each important sheet by name, then does a COUNT to make sure they all have something in them.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon 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!)
Hey it worked....Thanks a lot..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks