Hi, am very new to excel and need to make cells C2, D3, E3, D4,E4, D5, E5,D6, E6, D7, E7, D8, E8, D9, E9, D10, E10, D11, E11, D12 & E12 mandatory in an open sheet.
please help to stop closing the sheet before all these cells are filled. you may reach me at "jk.maina@yahoo.com"
So just to confirm.
You want the above listed cells filled before the excel sheet is allowed to close?
Try this code in the workbook_beforeclose module.
Keep in mind that users have the option to NOT enable macros when prompted and can thus defeat any VBA code.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks