Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba project explorer
With some workbooks, there are several "copies" of a worksheet displayed in
the vba project explorer, like table1, table101, table102 etc. Just on of them is displayed with the actual worksheet name in paranthesis after it. Where are they coming from and more importantly, is there a way I can get rid of them? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba project explorer
Be careful! The VBA project explorer lists the workbooks, worksheets,
chartsheets and forms that you (or someone) has created as part of that workbook. Also, if you have more than one workbook open, the VBA project explorer will list projects from those workbooks although they are not the active workbook. Before you delete anything from a project explorer at the office, be sure to check with co-workers to determine if what you intend to delete is something used by one of them in a shared file. If you are working with your personal computer at home, then you will only have yourself to blame if you delete something you needed. You might find some answers by double clicking the items in the project window and see what they look like. "president02" wrote in message ... With some workbooks, there are several "copies" of a worksheet displayed in the vba project explorer, like table1, table101, table102 etc. Just on of them is displayed with the actual worksheet name in paranthesis after it. Where are they coming from and more importantly, is there a way I can get rid of them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA project duplicated in Project Explorer | Excel Programming | |||
VBA Project Explorer list | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
VBA Project Explorer | Excel Programming |