Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mcinernj
-
VBAProject Password required when closing Excel
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.- mcinernj
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBAProject Password required when closing Excel
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...- mcinernj
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I get a msgbox to display in the foreground
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?- mcinernj
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I get a msgbox to display in the foreground
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- mcinernj
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
