Launch Script When Tab Is Opened

[ExcelAtEverything]

Hello all!

Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when opening a workbook, but I need it to occur when opening a tab. What I'm trying to do is to create a "warning" sort of message each time the database tab (DATA1) is opened. If the person runs were to open that particular tab and just start pressing the buttons (which run macros) without doing it in the correct order, it could break the sheet by disorganizing the table I have on the main (RANKER) sheet. On the other hand I can't lock or hide it because they will need to use it periodically (when a new store comes online & opens).

Thanks!

 

[jtakw]

Why is this a sticky?

 

[jtakw]

.

 

[Michael M]

@jtakw
I have no idea.....nor do I know how to create a Sticky...

 

[smozgur]

Why is this a sticky?

It is my mistake. Thanks for the heads-up.

Last night I received an urgent email from the OP requesting sensitive data removal, and I was on the phone at the time. So, I didn't realize that I accidentally clicked on the button while I was trying to remove the content.

Sorry for the confusion.

 

[Michael M]

@smozgur
Ok....no worries...

 

[smozgur]

Last night I received an urgent email from the OP requesting sensitive data removal, and I was on the phone at the time. So, I didn't realize that I accidentally clicked on the button while I was trying to remove the content.

Actually a bit more than this.

As a super unbelievable coincidence right at that moment, the host network company experienced a short outage that I needed to switch my attention immediately. Then, as you would guess, I didn't even notice that I made this thread the most famous one for 12 hours

Thanks again for the heads-up.

 

[Michael M]

a couple of more questions

- It needs to only insert 1 row at the bottom of each range on the MOR sheet.

...why if there are more than 1 new store to be entered ?

- It needs to insert a row at the bottom of the range on the "Store Data" sheet.

..don't you already have a table setup on the store data sheet.

- In the D column of the MOR sheet, it also needs to copy down the "Concatenate" formula from the rest of the D cells above.

again, why....the code concatenates the cells without the need for formulas

Can you upload the wrokbook to DropBox or similar....I don't seem to be reproducing the shatts as you have them set out.
I may be away for a few days, so hopefully somone else can step and refine the code

 

[Michael M]

@smozgur
Sooo....what you are saying is, We are part of famous!!!.....

 

[ExcelAtEverything]

Could someone translate for me? A sticky? Made this the most famous thread... how?

 

[Michael M]

@ExcelAtEverything
Read Post #44 then Post #46