Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking at a Excel file that in VB has Microsoft Excel Object that are
named like: Siz01_Customer(CustomerName) Siz02_Product(ProductName) Below all of are the Sheets that I expected to see. Many of the Siz sheets are blank or contain a limited amount of code, and in some cases the SheetName I would expect to show up as: Sheet1(PricingInfo) is showing up as: Siz03_Pricing(PricingInfo) Questions: (1) I have never seen this done before, how do you edit from "Sheet1" to "Siz03_Pricing"? (2) Is this a common practice or does/can this cause any type of reference problems? (3) How do you edit back to the SheetName? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel VBA Class Objects - Parent & Successor Objects | Excel Programming | |||
Using COM objects in Excel or VBA? | Excel Programming | |||
Objects in Excel | Excel Programming | |||
Dynamically Assign Objects to Form Objects. | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |