Dec 12, 2002 #1 MSUser Technical User Oct 31, 2000 33 0 0 US The file was created in Excel 4.0. It is listed in the VBA Project list, but cannot be open to edit?
Dec 12, 2002 #2 Dreamboat Instructor Nov 7, 1999 4,881 0 0 US It likely resides in your XLSTART folder. Have you tried Window-Unhide while you're in any Excel file or just after you open Excel? Anne Troy http://www.TheOfficeExperts.com Upvote 0 Downvote
It likely resides in your XLSTART folder. Have you tried Window-Unhide while you're in any Excel file or just after you open Excel? Anne Troy http://www.TheOfficeExperts.com
Dec 12, 2002 Thread starter #3 MSUser Technical User Oct 31, 2000 33 0 0 US The unhide button is grayed out and cannot be used. This la file is directly linked to another xls file only. Upvote 0 Downvote
The unhide button is grayed out and cannot be used. This la file is directly linked to another xls file only.
Dec 12, 2002 #4 Zathras Programmer Nov 12, 2002 3,317 0 0 US May or may not be significant, but if I remember correctly, Excel 4 used "old-style" macro sheets. (Not VBA.) Upvote 0 Downvote
May or may not be significant, but if I remember correctly, Excel 4 used "old-style" macro sheets. (Not VBA.)
Dec 12, 2002 1 #5 acron MIS Oct 19, 2001 476 0 0 IE Goto the Project in the VBE, select the ThisWorkbook object and enable the Properties window (F4). You should be able to set the IsAddin property to False. Then return to Excel and if the workbook is not visible, try Windows, Unhide. You may then have to unhide or find the XL4 macro sheets. A.C. Upvote 0 Downvote
Goto the Project in the VBE, select the ThisWorkbook object and enable the Properties window (F4). You should be able to set the IsAddin property to False. Then return to Excel and if the workbook is not visible, try Windows, Unhide. You may then have to unhide or find the XL4 macro sheets. A.C.
Dec 12, 2002 Thread starter #6 MSUser Technical User Oct 31, 2000 33 0 0 US Thank you acron. It worked! Upvote 0 Downvote