Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and determining which sheet the code is running under
Hi
I am calling code that resides within different sheets. So I start on sheet1 and press a go button the go button calls a function on sheet2, sheet3 etc. Within the code on sheet2 I need to grab the name of sheet2. I cannot hard code it as the sheets maybe renamed and I need the current sheet name. I have tried using ActiveSheet but this returns sheet1. Any ideas? thanks Jake |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and determining which sheet the code is running under
I am calling code that resides within different sheets.
So I start on sheet1 and press a go button the go button calls a function on sheet2, sheet3 etc. Within the code on sheet2 I need to grab the name of sheet2. I cannot hard code it as the sheets maybe renamed and I need the current sheet name. I have tried using ActiveSheet but this returns sheet1. is the code in the module of the sheet? Then use the keyword 'Me' in place of 'ActiveSheet'. -- Mit freundlichen Grüssen Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and determining which sheet the code is running under
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determining running counts | Excel Worksheet Functions | |||
running code | New Users to Excel | |||
Determining the Selection on a non-active Sheet? | Excel Programming | |||
Running Code on Each Sheet in an Excel Workbook | Excel Programming | |||
running VB code | Excel Programming |