Check activate sheet

  • Thread starter Thread starter efi
  • Start date Start date
E

efi

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

thanx.
 
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 (e-mail address removed)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ActiveCell on inactive sheet 8
Run macro from active workbook whose name keeps changing 20
Change event code Find .Activate does not activate Target.value 4
clear all sheets code 4
How to make A1 the active cell in all visible worksheets ? 3
sheet event wait for another event? 6
application.activesheet, should I use it? 3
code help 0

Back
Top