ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBE acting weird - help (https://www.excelbanter.com/excel-programming/351704-vbe-acting-weird-help.html)

dpenny[_4_]

VBE acting weird - help
 

1st, am not a guru, but not a newbie either. I do 50 lines of VBA a
month.

2nd, I have an active case with MS re VBE killing a workbook, all after
I upgraded to SP2.

3rd. is the following normal, and how do I reverse it.

I just copied a whole XL workbook to a new name.
1) in VBE I see both projects, one under old name, one under new name
2) I used to see VBE display as a tree with +- button for sheets,
forms, modules, etc. This is completely gone and I see a linear list
of the objects in a project, no more tree view.

What did I do?
How to return to tree view?
How to get rid of project A in its copy whose is name workbook B, and
thus project B? When I click & got to Edit, all things are greyed out.
Hugh?

Thanks for any advice.


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=505970


Damon Longworth

VBE acting weird - help
 
Temporary files can cause "weird" behavior. Try deleting all temp files. A
reboot can cure many ills.

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
"dpenny" wrote in
message ...

1st, am not a guru, but not a newbie either. I do 50 lines of VBA a
month.

2nd, I have an active case with MS re VBE killing a workbook, all after
I upgraded to SP2.

3rd. is the following normal, and how do I reverse it.

I just copied a whole XL workbook to a new name.
1) in VBE I see both projects, one under old name, one under new name
2) I used to see VBE display as a tree with +- button for sheets,
forms, modules, etc. This is completely gone and I see a linear list
of the objects in a project, no more tree view.

What did I do?
How to return to tree view?
How to get rid of project A in its copy whose is name workbook B, and
thus project B? When I click & got to Edit, all things are greyed out.
Hugh?

Thanks for any advice.


--
dpenny
------------------------------------------------------------------------
dpenny's Profile:
http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=505970




All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com