Re: Extra Sheet in Workbook (Menu Sheet)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jack Gillis (XXXXXXXX_at_widomaker.com)
Date: 02/27/05 

Date: Sun, 27 Feb 2005 05:27:23 -0500

Thank you, Don. It was hidden. I did unhide it found it useless and
deleted it. Like J. Buffett's tattoo, I don't have a clue how it got
there.

"Don Guillett" <donaldb@281.com> wrote in message
news:u3f$8LFHFHA.3484@TK2MSFTNGP12.phx.gbl...
> By untabbed, might you mean it was hidden? It probably did not get
> there by
> itself or devine intervention. So, you could maybe unhide it and
> remove or
>
> for each sh
> if sh.name <> "Menu" then
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> news:1121rb0tn5k8nb1@corp.supernews.com...
>> I was doing some work in VBA for a macro and could get it to work on
>> some workbooks but not others. The macro uses a For loop to cycle
>> through all the sheets in a workbook and perform identical operations
>> on
>> each. I found the problem with the offending workbooks and can fix
>> the
>> macro to make it work on them but then it won't work on the others.
>>
>> The problem is some workbooks have an 'un-tabbed' *** named Menu
>> ***
>> according to VBA's Project Explorer. It is *** 11 and how it got
>> there
>> with that number, I haven't a clue for my other sheets are 1 through
>> 6.
>> I discovered this when I examined what Sheets.Count returned and
>> found
>> it was one more than the number of Tabs in the workbook.
>>
>> I've no idea what 'Menu ***' is or where it came from. Is it
>> really
>> needed? I can't find a way to delete it anyway. I can program
>> around
>> it, I think if I can find a way to detect its presence, but I wonder
>> how
>> many other such things can crop up to mess up what I hope to be a
>> general purpose macro.
>>
>> I hope I have made the question clear and I will really appreciate
>> any
>> insight to this vexing thing.
>>
>>
>
>

Quantcast