Which Worksheet is Active?

  • Thread starter Thread starter Bishop
  • Start date Start date
B

Bishop

If I'm working in VBE and I need to know what the active Workbook is or which
Worksheet is active, how do I figure that out? Is there some tool that will
tell me this?
 
msgbox activeworkbook.name
msgbox activesheet.name
(or, activeworkbook.activesheet.name)

HTH,
Keith
 
hi
Sub whatisit()
Dim awbn As String
Dim awsn As String
awbn = ActiveWorkbook.Name
awsn = ActiveSheet.Name
MsgBox awbn
MsgBox awsn
End Sub

regards
FSt1
 
This is perfect. How do I add a shortcut key to this? Say I wanted to use
ctrl+q to run this?
 
hi
install the macro in a standard module then on the menu bar....
Tools>macro>macros
highlight the macro then click the options button. add your shortcut then ok
out.

Regards
FSt1
 

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

Rookie Question - Activating Worksheets 2
Change Cursor Image if Workbook is not the Active Window 2
Determining the Active Worksheet 2
How to get worksheet_activate code to run when a workbook is opened 1
Macro shortcuts are running macros in different open workbook 3
Worksheet appears briefly before UserForm opens 4
Copy a table from one workbook to ALL worksheets in a different wb 1
Macro runs within VBE, but does not run to completion via a hotkey 8

Back
Top