Hi,
In which command can I check which sheet is activate at the moment?

thanx.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Efi,

ActiveSheet will always refer to the sheet that is presently active. E.g.,

MsgBox "Active Sheet: " & ActiveSheet.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"efi" wrote in message
...
Hi,
In which command can I check which sheet is activate at the moment?

thanx.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

MsgBox ActiveSheet.Name
This will give you the name

With this you can run code if the sheet Mysheet is active

If ActiveSheet.Name = "Mysheet" Then
'your code
End If


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message ...
Hi,
In which command can I check which sheet is activate at the moment?

thanx.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/