On Jul 1, 10:56*am, Lance <mzx...@yahoo.com> wrote:
> Hello,
>
> I have an excel file with currently about 10 sheets. *It has 1 module,
> and some code in the ThisWorkbook Object as well as 1 of the sheets.
> Each tab is a daily report - *occasionally, I manually delete
> worksheet tabs to manage the file size.
>
> I just noticed that in the VBA project, there are many blank (i.e.
> Sheet10, Sheet11, Sheet12, Sheet13, etc) Microsfot Excel Code Objects
> (31 to be exact) - these objects can be activated and code can be
> entered. *However, there are only 15 existing worksheet tabs...
>
> The only other notable observation is that the icon for the non-
> existing objects in the VB project explorer window are the green Excel
> "X", whereas code objects with associated valid worksheet tabs are a
> small black table icon.
>
> I suspect the VBA project is corrupt and I will have to figure out a
> way to try and start the workbook from scratch...
>
> But has anyone experienced anything like this before, and what can I
> do to prevent this from happening in the future?
>
> Thanks,
>
> Lance
Lance,
Have you checked what the Visible property is set to for your "blank"
worksheets? Do you want to delete these "blank" worksheets? (No, I
haven't experienced this "green Excel X...small black table icon"
difference you mention).
Best,
Matthew Herbert
|
Similar Threads
