I have written a drawing programme in excel to produce floor plans &
elevations for sheds. I now want to distribute the programme but need to have
all of the scaling to change to the current users screen size. I am after
ways of VB knowing what screen size the user has & how I can set my page tops
etc. to suit this so the shapes are positioned correctly on the page. At the
moment I have hard coded in where my shapes are to start positioning but this
is no good when a new user has a different monitor size as it throws it all
over the screen.

Also am looking for ways of locking users out of code and creating
distributor versions so that we have the ability to monitor how they are
using there programme & what they are using it for.

Urgent help required.

thanks
--
SS