Calling active sheet from another sheet will return the name of it's
self, it's a class modual,
try running the same code from a standard modual

vis:

Public Sub InAStanardModual()

Sheet1.Activate
MySheet = ActiveSheet.Name

End Sub

wil return the name of sheet one.


another way would be to use the code name, as shown in the vbe window:
sheet1(MyWorkSheetName)

where the "MyWorkSheetNAme" is the name of the worksheet on the tab.

to call a procedure in a standard modual you simple add the name of
the procdure to the calling event, i.e


Button1_click

InAStanardModual

end sub
would run the about code from modual1

good luck

ross