| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path name in title bar-READ ONLY prob
I have a tough one...I put the code
ActiveWindow.Caption = ActiveWorkbook.FullName in a workbook......however, if the file comes up as "read-only" the (read only) message is gone from the title bar.....it is very important that users see that they are in a "read only" file....is there any way to get the full path name & the read only message to appear in the title bar? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Path name in title bar-READ ONLY prob
Try something like
Dim WB As Workbook Set WB = ActiveWindow.Parent If WB.ReadOnly = True Then ActiveWindow.Caption = "My Text (read only)" Else ActiveWindow.Caption = "My Text" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Deeds" wrote in message ... I have a tough one...I put the code ActiveWindow.Caption = ActiveWorkbook.FullName in a workbook......however, if the file comes up as "read-only" the (read only) message is gone from the title bar.....it is very important that users see that they are in a "read only" file....is there any way to get the full path name & the read only message to appear in the title bar? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Path name in title bar-READ ONLY prob
Very good! Thanks much!
"Chip Pearson" wrote: Try something like Dim WB As Workbook Set WB = ActiveWindow.Parent If WB.ReadOnly = True Then ActiveWindow.Caption = "My Text (read only)" Else ActiveWindow.Caption = "My Text" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Deeds" wrote in message ... I have a tough one...I put the code ActiveWindow.Caption = ActiveWorkbook.FullName in a workbook......however, if the file comes up as "read-only" the (read only) message is gone from the title bar.....it is very important that users see that they are in a "read only" file....is there any way to get the full path name & the read only message to appear in the title bar? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Full path-name in title bar ? | Excel Discussion (Misc queries) | |||
| Full path in title bar | Excel Discussion (Misc queries) | |||
| Full path in title bar | Excel Discussion (Misc queries) | |||
| Can the full path be shown in the Title Bar? | Excel Discussion (Misc queries) | |||
| Show full path title in title bar? | New Users to Excel | |||
Linear Mode
