LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA Class Objects - Parent & Successor Objects [email protected] Excel Programming 1 January 15th 07 12:06 AM
Using COM objects in Excel or VBA? Afshar Mohebbi Excel Programming 4 July 16th 06 07:38 AM
Objects in Excel [email protected] Excel Programming 2 June 26th 06 12:43 PM
Dynamically Assign Objects to Form Objects. The Vision Thing Excel Programming 2 December 11th 04 04:02 PM
Unable to remove Sheet objects in the Microsoft Excel Objects Adrian[_7_] Excel Programming 1 August 26th 04 10:49 PM


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"