• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there a way to check file name of defined worksheet using key board shortcut in VBA

ThrottleWorks

Excel Ninja
Hi,

This is not a problem actually however I want to know, can we check file name of defined worksheet.

Is there any technique or shortcut available in VBA.

For example, I can check worksheet name in Immediate window.

But if I want to check, from which file this worksheet is defined, how do I do this.
Can anyone help me in this please.
 
Hi,

in Immediate window, to know the workbook for example :
?activesheet.parent.fullname and hit Enter key …
In fact it's the same as within a VBA code, TBTO rule !
 
Hi @Marc L sir, thanks lot for the help. Before posting, I tried till sheet.name.
However I could not see any pop-up after inserting . to sheet.name.

This left me in a lurch and I posted here. :eek::mad:
 
Back
Top