Hi guys.

I have created a custom class based upon a worksheet. I was under th
impression that by coding:


Code
-------------------

Public WithEvents shGutter As Worksheet

-------------------


You would create a class that you could then extend with new propertie
and methods.

I've got the new properties and methods in place, but now all th
standard methods and properties such as .RANGE and the shape
collection and all the rest have dissappear.

What do I need to code to create a custom class based on a worksheet s
that it contains both the standard properties and methods for
worksheet as well as my own extentions ??

Cheers!

Regards

Rich (and his can of worms.....

--
Rich_
-----------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=38672

Rich,

Do you want to take this off-line and send me a workbook, and we can discuss
it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rich_z" wrote in
message ...

Hi guys.

I have created a custom class based upon a worksheet. I was under the
impression that by coding:


Code:
--------------------

Public WithEvents shGutter As Worksheet

--------------------


You would create a class that you could then extend with new properties
and methods.

I've got the new properties and methods in place, but now all the
standard methods and properties such as .RANGE and the shapes
collection and all the rest have dissappear.

What do I need to code to create a custom class based on a worksheet so
that it contains both the standard properties and methods for a
worksheet as well as my own extentions ??

Cheers!

Regards

Rich (and his can of worms.....)


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile:
http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=386722