A BeforeSave that I can't do
Hi!!
I need a macro or code to prevent saving if the correct data is not entered.
I have this workbook and if the Status column says Inactive it will mark the Reason column in yellow and promt to Select option, but until they not select a valid option the workbook can't be saved, how can this be done?
I need that a message popup and says "Please complete the information before saving"
I attached my file so it can be better understand
TestSave.xlsx
Appreciate your help
Last edited by jjislas; 08-29-2012 at 11:35 PM. Reason: Solved
Paste to ThisWorkbook module in your project:You must save workbook in *.xlsm format.
Please Login or Register to view this content.
Artik
Thanks Artik already added your code to the Module but it still let me save and save as the workbook, what can be wrong?
Not in standard module, eg Module1.
ArtikOriginally Posted by Artik_PL
Last edited by JBeaucaire; 08-29-2012 at 07:56 PM.
Yes I paste it there.
I went to MVBA with alt+F11 then Insert - Module and Module1 is created, I copypaste your code there but nothing happened
oh jjislas
Look to the attached file - THISWORKBOOK MODULE
Artik
Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks