MsgBox containing Data along with password to close the MsgBox

Hi Experts,

I am looking for a macro that will do the the things mentioned below

Macro will be placed in a macro.xlsm
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

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)

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)


Thnx For the Help
https://www.ozgrid.com/forum/index.p...se-the-msgbox/
https://www.excelguru.ca/forums/show...4480#post44480