Help using form as menu
 

I am trying to use an Excel User Form as a menu The form will have
controls that open other workbooks.

However I only want the Menu Form to display in the main workbook
(Book1.xls), and when the next workbook opens (book2.xls) the form
would not be presented.

Once I open the form, it is displayed in front of all subsequent
workbooks.

How can I limit the display of the form to only the first workbook.

Thanks in advance


--
rmeix
------------------------------------------------------------------------
rmeix's Profile: http://www.excelforum.com/member.php...o&userid=27737
View this thread: http://www.excelforum.com/showthread...hreadid=472446

Help using form as menu
 

in the code that displays the form, put an if statement against the
activeworkbook

if Ucase(activeworkbook.Name) < "BOOK1.XLS" then exit sub

' show form

--
Regards,
Tom Ogilvy

"rmeix" wrote in
message ...

I am trying to use an Excel User Form as a menu The form will have
controls that open other workbooks.

However I only want the Menu Form to display in the main workbook
(Book1.xls), and when the next workbook opens (book2.xls) the form
would not be presented.

Once I open the form, it is displayed in front of all subsequent
workbooks.

How can I limit the display of the form to only the first workbook.

Thanks in advance


--
rmeix
------------------------------------------------------------------------
rmeix's Profile:
http://www.excelforum.com/member.php...o&userid=27737
View this thread: http://www.excelforum.com/showthread...hreadid=472446