Thanks for the tip Tlb...I will try this.
The reason for the password is that this program is for a client and I don't want them to be able (easily) to mess up the code.
I have a Macro in Excel 2002 that when the workbook is opened runs and updates information contained within it.
I have protected the Project from viewing with a password.
When the user saves and closes the workbook and excel they are prompted for the VBAProject Password.
They can click...
The macro that I am running is Shipping.AVB and within it I have the following...
iResponse = MsgBox("Previous processing of " & sNewFileName & " was not completed...finish processing now?", vbYesNo)
This is the msgbox that shows in the task bar. How would I use AppActivate in this situation?
I am running a VBA program. During this program I am doing a check of something...depending on the result I wish to present the user with a vbYesNo msgbox. This works but it shows in the Task Bar. I want this message to popup in front of them.
Any ideas?
Thanks,
Jeff
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.