Display workbook filename in title bar and use personal workbook

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Display workbook filename in title bar and use personal workbook

FAQ

Thread Tools

Display Modes

08-04-2022, 02:56 AM

Guessed

Windows 10 Display workbook filename in title bar and use personal workbook

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,166

To get the macro to run without manually asking it to run, you need to put it in the ThisWorkbook module and use the built-in names associated with particular events. I would use these ones

Code:

Private Sub Workbook_AfterSave(ByVal Success As Boolean)
  ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub

Private Sub Workbook_Open()
  ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

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