Switching userfoms
 

Perhaps you could establish a global variable which the activate event
checks before it executes the growth code. Have userform2 set the variable
to prevent the growth.

--
Regards,
Tom Ogilvy


"nath" <n@n wrote in message ...
Hi

I have a userform, userform1 that when selected to be
opened, opens the form with it rising from the centre of
the screen. There are various controls on this form,
where one is a button to see a financial year week number
by clicking a date on the calendar. The calendar is on
userform2, which shows fine. However when i close
userform2, even though userform1 is still visible, it
still runs the code to make the form extend.

I have used the UserForm1_Activate for this "growth" code.

It has to appear in this way.

Dows anybody know how to just switch between the forms
rather than deactivate them

i am using userform2.show when the button is clicked.

TIA

Nath.