MsgBox containing Data along with password to close the MsgBox

letmein

New member
Joined
Jan 25, 2017
Messages
7
Reaction score
0
Points
0
Location
london
Excel Version(s)
2013
[FONT=&quot]Hi Experts,[/FONT]



[FONT=&quot]I am looking for a macro that will do the the things mentioned below[/FONT]



[FONT=&quot]Macro will be placed in a macro.xlsm[/FONT]

[FONT=&quot]macro.xlsm & sample.xlsb both are located in different path so the path should be hardcoded in the macro, so i can change it as per my needs[/FONT]



[FONT=&quot]I am looking for a msgbox which contains the data as i mentioned in the sample file (The data will change but when i run the macro then i need a msg box of the same along with the data in the msgbox & that msgbox will only be closed by the paasword, cancel option should not work,without putting paasword in it that msgbox will not be closed)[/FONT]



[FONT=&quot]I have Highlighted the data for which i need a msgbox(In actual file there will not be any highlighted data, I have highlighted it only for understanding purpose)[/FONT]





[FONT=&quot]Thnx For the Help
https://www.excelforum.com/excel-pr...password-to-close-the-msgbox.html#post5383814
https://www.ozgrid.com/forum/index....data-along-with-password-to-close-the-msgbox/
[/FONT]
 

Attachments

  • sample (4).xlsb
    14.3 KB · Views: 9
Top