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
 
Back
Top