I have a spreadsheet that I have inherited (believe it was written in 95).

Anyway, one of the buttons has a macro attached called LANDMAC!LandIt.

When I try to find the macro, it is not in the macro list.

I went to File...Properties...Contents and under "Excel 4.0 Macros" it
lists LANDMAC.

Where can I see the contents of this Macro? I thought it might be in
another file, but I can't find it.

Please Help!

Hugh O'Donnell

Have you looked in all of the worksheets?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Hugh O'Donnell" <(E-Mail Removed)> wrote in message
news:Xns99D3A880CE971hughdoldrums@66.250.146.128...
>I have a spreadsheet that I have inherited (believe it was written in 95).
>
> Anyway, one of the buttons has a macro attached called LANDMAC!LandIt.
>
> When I try to find the macro, it is not in the macro list.
>
> I went to File...Properties...Contents and under "Excel 4.0 Macros" it
> lists LANDMAC.
>
> Where can I see the contents of this Macro? I thought it might be in
> another file, but I can't find it.
>
> Please Help!
>
> Hugh O'Donnell

What exactly do you mean my "looked in all the worksheets"? It isn't
listed if I go to Tools...Macro...Macros. There isn't a tab called
"LANDMAC" (which is what happens if I go to add a new Excel 4.0 Macro). Is
there some way I don't know about to hide a tab?

Thanks,

Hugh

"Don Guillett" <(E-Mail Removed)> wrote in news:eCK39uoFIHA.1188
@TK2MSFTNGP04.phx.gbl:

>
> Have you looked in all of the worksheets?
>

Hugh -

Format | Sheet | Unhide ?

- Mike


"Hugh O'Donnell" <(E-Mail Removed)> wrote in message
news:Xns99D3E9B248973hughdoldrums@66.250.146.128...
> What exactly do you mean my "looked in all the worksheets"? It isn't
> listed if I go to Tools...Macro...Macros. There isn't a tab called
> "LANDMAC" (which is what happens if I go to add a new Excel 4.0 Macro).
> Is
> there some way I don't know about to hide a tab?
>
> Thanks,
>
> Hugh
>
> "Don Guillett" <(E-Mail Removed)> wrote in news:eCK39uoFIHA.1188
> @TK2MSFTNGP04.phx.gbl:
>
>>
>> Have you looked in all of the worksheets?
>>
>

First off, let me say, "Thank You, Thank You, Thank You". Secondly, I'm a
dumba$$!

Found it now! Thanks, Mike!

"Mike Middleton" <(E-Mail Removed)> wrote in news:OTpzf5sFIHA.2268
@TK2MSFTNGP02.phx.gbl:

> Hugh -
>
> Format | Sheet | Unhide ?
>
> - Mike