Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA forms question

  Asked By: Anpu    Date: Aug 31    Category: MS Office    Views: 807
  

Is it possible to invoke a VBA form in Excel without invoking a
workbook/Worksheet first?
I am building an application and need to use forms for data entry.
Then I don't need the spreadsheet. Is it possible to display the form
while hiding or deleting the worksheets?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Garrett Brooks     Answered On: Aug 31

Yes.
Application.Visible = False

Put this line in the Workbook_Open() event (in the Thisworkbook code
module).

(Override it by holding down the shift key while opening the file.)

 
Answer #2    Answered By: Willis Hill     Answered On: Aug 31

Another quick question:
What is the difference between Auto_Open() and WorkBook_Open(), and
what are the appropriate situations for them to be used?

 
Answer #3    Answered By: James Williams     Answered On: Aug 31

see:
http://www.dicks-blog.com/archives/2004/08/18/runn
ing-macros-when-a-workbook-is-opened/

 
Didn't find what you were looking for? Find more on VBA forms question Or get search suggestion and latest updates.




Tagged: