I’m working on an Excel VBA form. This form has a button which will attach an object in the excel file.
Once the user will click this button and attaches a file then it should say that file was attached successfully and turn the button to green color if the file was not attached it should say attaching the file is compulsory.
Also it should not allow the user to save the file if they have not attached the file.
Appreciate a quick response on the above.