I have used data validation to ensure entries into certain cells fall between certain values. All works well. However, I would like the pop-up box containing the prompt to pop up in a specific place on the worksheet everytime.

So far I have discovered that if you drag the pop-up to the desired location, it will stay there and all prompts from any validated cell appear in it - as opposed to being in a pop-up near the cell itself.

This would be good enough, but after shutting the sheet, then reloading it, I find the pop-ups return to their old ways, appearing near the cell in question.

I have also noticed that the messages appear in bubbles attached to the Office Assistant should this pesk be open at the time. This is not a problem. I just want the box to stay put when a pop-up appears when using a data validated cell.

Any thoughts??