need a popup mesage to open automatically when certian sheet is clicked

I need a pop up to automatically open when a user clicks on a certain sheet on my shared workbook. I would like this to be automatic as there is little to no information manually entered the the sheet.


I've tired this but it only works when the workbook is opened not the certain sheet I need it on. I don't know how to change...

Please Login or Register  to view this content.

put this in the code module of the worksheet

Please Login or Register  to view this content.

Hi, Andy,

I just wonder what the return value for an OKOnly-Msg may be used for (I know, TO has put in the code - but shouldnīt that be pointed out?).

Ciao,
Holger

Morning Holger

I would agree but i tend to find it's easy to get bogged down in detail.... So my approach is to develop a crude working model and then refine it down however a lot of people "abandon ship" once it's working satisfactorily..... If the OP wants to take it further that's fine but if not, it saves me uneccessary time and effort ...

I think i slipped into that methodology because I used to train Technicians on the job and i generally found they just wanted to know how to solve their specific problems without going into the finer detail..

Hi, Andy,

looking at what happens when I take whatever action I really canīt fully agree on that.

Click on the closing X when you run

Please Login or Register  to view this content.

There is no choice so the title is obsolete, and furthermore the date time stamp is put in the immediate window. But I wanted the modal window to close and not run the further code. So the code maybe should be altered to

Please Login or Register  to view this content.

This comes to my mind when I see a variable being used which doesnīt much sense but blows up the code while it isnīt used in the further code.

Ciao,
Holger

That makes sense ....... I just built on the code provided though cos I'm lazy like that .....