thanks, fyi:
Private Sub Worksheet_Activate()
Me.Range("b3").Value = Me.Name
End Sub
Private Sub Worksheet_Calculate()
Me.Range("b3").Value = Me.Name
End Sub
'then i protected b3
- Peter
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 06 February 2003 15:01
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] OT: xls
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/htm
l/deovrWorkingWithMicrosoftExcelObjects.asp
http://www.mrexcel.com/articles.shtml
http://www.erlandsendata.no/english/vba/index.htm
I'm sure you'll find the answer in one of the above,
Rafe Fitzpatrick
Senior Developer
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
