hi experts
I no know if what I ask for it can be possible . so what I want macro in workbook open event . so when open the file and shows
disable or enable macro and the user disable the macro then should pop up message " sorry you have to enable macro" and should close the whole application excel . but I have two things in my mind . first I'm afraid next time when open the file doesn't show two choices to enable the macro or disable then the user can use the file . second I don't do that for any file just by specific name of file to overcome applying for all excel files . I know some body suggests by protect the file . I wouldn't this way. if it's possible can do that as I mentioned will be great
thanks in advance
I no know if what I ask for it can be possible . so what I want macro in workbook open event . so when open the file and shows
disable or enable macro and the user disable the macro then should pop up message " sorry you have to enable macro" and should close the whole application excel . but I have two things in my mind . first I'm afraid next time when open the file doesn't show two choices to enable the macro or disable then the user can use the file . second I don't do that for any file just by specific name of file to overcome applying for all excel files . I know some body suggests by protect the file . I wouldn't this way. if it's possible can do that as I mentioned will be great
thanks in advance