Xiazer,

I'd declare without the New & use the Workbook_Open method to initialise
(Set x =New x).

I'd probably declare it private to the code module & set Property Get/Set
methods up to access it, but that would be doing a belt & braces job.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Xiazer" wrote:


I know when a custom class this is the proper syntax
Dim SSheet as New SSched
but I want to know is how to change it globally. I use that same
syntax uptop of the sheet to set it globallly, but it seems like
whenever I access the page or something it resets the variable as a new
variable and all my information is reset.

if I *Dim SSheet as SSched* you know with out the "new" I always get an
error. my question is how do I set a Global Custom Class Variable?


--
Xiazer
------------------------------------------------------------------------
Xiazer's Profile: http://www.excelforum.com/member.php...o&userid=31581
View this thread: http://www.excelforum.com/showthread...hreadid=544048