Thread: Excel Objects
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Troubled User Troubled User is offline
external usenet poster
 
Posts: 85
Default Excel Objects

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?