Caption

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
| 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 menubar incompatibility? 1
using two cell references to make up the save as file name 3
Excel crashes and restarts when accessing newly created worksheet 2
Stopping a macro to edit the template then re-saving the macro for use 4
how can i know the last user who open the workbook 2
button name scope and Caption 2
How to enumerate buttons on user form 2
Can't delete sheets 8

Back
Top