Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caption
Hi All,
I am using Excel 2000. On opening a particular workbook I have the following: Application.caption = "A" However, the caption shows "A - workbook name" How do I make it to just show "A" and not the wrokbook name as well. Thanks in advance Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caption
This happens when the worksheet window is maximized and I do not think you
can prevent Excel from putting the workbook name in the caption in that circumstance. You can keep the window from being maximized through Tools, Protection, Protect Workbook, Windows though... -- Jim Rech Excel MVP wrote in message ... | Hi All, | | I am using Excel 2000. On opening a particular workbook I | have the following: | | Application.caption = "A" | | However, the caption shows "A - workbook name" | | How do I make it to just show "A" and not the wrokbook | name as well. Thanks in advance | | Regards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caption
Thanks. This is very useful to know. Regards -----Original Message----- This happens when the worksheet window is maximized and I do not think you can prevent Excel from putting the workbook name in the caption in that circumstance. You can keep the window from being maximized through Tools, Protection, Protect Workbook, Windows though... -- Jim Rech Excel MVP wrote in message ... | Hi All, | | I am using Excel 2000. On opening a particular workbook I | have the following: | | Application.caption = "A" | | However, the caption shows "A - workbook name" | | How do I make it to just show "A" and not the wrokbook | name as well. Thanks in advance | | Regards . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
label caption | Excel Discussion (Misc queries) | |||
Caption Property | Excel Discussion (Misc queries) | |||
Caption of a button | Excel Programming | |||
caption sensitivity | Excel Programming | |||
Caption on Menus | Excel Programming |