ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active application (https://www.excelbanter.com/excel-programming/304601-re-active-application.html)

sp00nix[_3_]

Active application
 
Put this in your ThisWorkbook object.


Code
-------------------

Private Sub Workbook_Open()
Application.Visible = True
UserForm1.Show
End Sub

-------------------


Let me know how it goes, if it doesn't work - show me the code you wer
using so i can get a better idead what you want

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com