Help using form as menu

  • Thread starter Thread starter rmeix
  • Start date Start date
R

rmeix

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
 
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
 
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

Help with activating window from Application.GetOpenFilename 4
How to Refer to Another Excel Workbook 1
Excel 2013 menubar incompatibility? 1
VBA to open a shortcut to a workbook 3
help with a basic code? 0
User defined menu stops working when workbook saved with a newname??? 4
Windows().Activate vs Workbooks().Activate 4
workbook error - please help 1

Back
Top