how remove (delete) VBA Project

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: how remove (delete) VBA Project

  1. #1
    New Member
    Join Date
    Dec 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how remove (delete) VBA Project

     
    My personal.xls file is in my XL start up file so that is what I first see when I go to use excel. I entered some data on the personal.xls spreadsheet which I'll call "stock data" By mistake I saved this file without transferring it to a regular Excel workbook as I usually do. Now "stock data" always opens along with a blank personal.xls sheet. This occurs even when I remove the "stock data" file from the XL start up folder.

    The VBA Project Explorer now lists 2 projects, i.e. personal.xls and stock data.xls. How can I delete or remove this stock data project? The remove option is greyed out when I highlight the project or the page or the workbook shown under the project.

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: how remove (delete) VBA Project

      
    Personal.xls is a hidden workbook. You can unhide it by selecting Window | Unhide. Once visible, you can delete the contents of the worksheets, save and re-hide the workbook.
    That should hopefully solve the problem.

    Denis

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com