Most likely the .xlt has it's own "TopMost" routine that overrides the one
you are setting.

There is a way to "force" your form to the front but I can't recall all the
coding details right now and afraid I don't have time to look them up. But
the method involves setting a timer and using the timer to continually
reposition your form as TopMost. You have to be careful with the timer
interval: too short will be constantly using your processor and too long will
lead to flicker. And if any other form uses this same method then there will
be conflicts and flicker. But it is the only way I know to keep the form on
top even if another app tries to make itself the topmost.
--
- K Dales


"Henry Stockbridge" wrote:

Hello,

Thanks for the code. The problem still persists. (Perhaps I placed
the code in the wrong two spots.)

I created a new module in the project for the code related to the API
functions. Then I added one line of code to the bottom of the
Worksheet Open event to reference the TopMost subroutine. When the
..xlt is opened, I see the flicker of the form, but it lands in the back
again. If I attempt to open it again, it lands on top.

Any other ideas?

Thanks,

Henry