Hey,
I want to show an information msgbox only once (or 2 times) when I open a tab, each time I open the file
Can someone help me further?
thank you!
Koen
Hey,
I want to show an information msgbox only once (or 2 times) when I open a tab, each time I open the file
Can someone help me further?
thank you!
Koen
Check out the workbook_open event and the worksheet_activate event
Indeed, but I want this info to be shown only once when I open a tab. So if I open this tab twice, the msgbox can no longer be shown.
I open the file a second time and I open this tab again, then the msgbox can be shown once again, no matter how many times I open this tab.
In a standard module.
In worksheet module.Please Login or Register to view this content.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
No, now i see the box, click 'OK' and then a new msgbox 'done'.
when i open the tab again, the msgbox shows again and thats not what i want.
Please Login or Register to view this content.
Last edited by davesexcel; 02-24-2019 at 07:56 AM.
Put something on the sheet, if that cell = something, then show msgbox, if it = something else, then don't show the msgbox.
When you close the workbook, then make the cell = something before saving
alternatively, a static variable may suffice?
Please Login or Register to view this content.
Als je code niet begrijpt vraag er dan achter ipv te zeggen dat het niet werkt.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks