Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ChangeEventMacro to unknown SheetName
Hi All............
I am making a small program in which I open a second Excel workbook and extract a sheet from it into my Main workbook. I do not know the name of the sheet, and assign it "UserSheetName" variable, and then I can populate and manipulate data on that sheet at will.....and close te second workbook......that part all works fine. What I would like to do now, is from a macro in my Main workbook, I would like to create a ChangeEvent macro into to that "UserSheetName" sheet that is now located also in my Main workbook. Is this a doable thing? Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheetname | Excel Worksheet Functions | |||
Automatically update SheetName in workbook sub if SheetName changes | Excel Discussion (Misc queries) | |||
Does anyone see this .xls]sheetname? | Excel Worksheet Functions | |||
sheetname value | Excel Programming | |||
SheetName | Excel Programming |