|
|
|
|
#1
07-30-2022, 01:35 PM
|
|||
|
|||
I moved this into the Excel programming forum. That way others looking for answers will be more likely to find it.
The following may help you: Copy your macros to a Personal Macro Workbook 
|
|
#2
07-31-2022, 08:11 AM
|
|||
|
|||
|
I google it and found the solution below. However, the code needs to be run each time the excel file is open in order to get the path displayed on the title bar
------------------ Sub showCaption() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub ------------------
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I copy a workbook to another workbook and keep the formatting within the new workbook | excelforsue | Excel | 3 | 09-15-2020 03:37 AM |
| Macro Personal Workbook does not load in Excel 2016 | Intruder | Excel Programming | 0 | 01-21-2017 05:44 AM |
| Personal Macro Workbook Does Not Load | WRowan | Excel | 1 | 06-23-2016 08:26 AM |
| data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
Windows 11 
Office 2021
Hybrid Mode