Pop up windows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I've created a simple macro where you click a button and a new workbook is
created, with some info pasted in.
How do I make it so that the orginal window stays maximised and the new
window say only a 1/3 in hight centered in the middle of the screen. So as
to give the impression that it is a pop-up window, simlar to a pop up form in
access.

Thanx
 
In Excel when one worksheet window is maximized they all are.

If you make sure the active window is not maximized
(Activewindow.WindowState = xlNormal) then you can position and size your
"popup" window.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I stop a windows Media player pop up on my PC 3
Create Pop-Up quiz Window with yes no questions 0
Pop-up form that creates record that links 1:1 to main form 0
MsgBox Positioning 2
Pop up Windows Question 6
POP up Box 2
Form Toolbox pops up? 4
Warning pop up window 4

Back
Top