Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Start Vba Project

  1. #1
    Join Date
    21st July 2004
    Posts
    78

    Start Vba Project

    I never knew how to start and name a new project in Excel VBA. Will someone explain how to?

    Thank you for your response.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    13th July 2007
    Posts
    209

    Re: Starting A Vba Project

    When you create a new workbook in Excel, it automatically contains a VBA project. Each workbook can only have one.

    You can rename the project in the Project Explorer window by right-clicking the project (top-level node saying "VBAProject (Workbook name)") you want to rename and click VBA Project Properties... and assign a new name in the Project Name field.

    Simple as that.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678

    Re: Starting A Vba Project

    A VBA project is automatically created when you create a new workbook.

    To view it, open the visual basic editor - It is named the same as your workbook

    VBAProject (YourFileName.xls)
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  4. #4
    Join Date
    21st July 2004
    Posts
    78

    Re: Start Vba Project

    Thank you Will and Fencliff.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. New Project Start
    By PTG258 in forum EXCEL HELP
    Replies: 10
    Last Post: June 5th, 2006, 22:23

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno