application.caption

technix

Active Member
Joined
May 19, 2002
Messages
326
If I use

Code:
application.caption = "my program"

it will display

my program - file name

is there a way to drop the file name

TIA

Derrick
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
I PUT THE CODE IN THE IMMIDIATE (ALT-F11 & CNTRL-G) IF I JUST ENTER THE FIRST LINE IT WORKS ONE TIME AFTER I SAVE IT AND RE-OPEN THE FILE THE CAPTION DOESN'T SHOW UP JUST THE SAME DEFAULT HEADING WHAT AM I DOING WRONG..I USE EXCEL 2000..COLLEEN
 
Upvote 0
Hello Colleen,

Why are placing your code in the immediate window? Please post the problematic procedure (which belongs in a normal module).

Incidentally, nice to see your Shift button is no longer stuck! :)
 
Upvote 0
It's hard to prescribe a medication based on my readings, I don't understand the described symptoms/infliction...

Regarding my mentioning of the immediate window, it came from your original post:

colleen said:
I PUT THE CODE IN THE IMMIDIATE
{snip}
I'm fairly certain that whatever code your referring to does not belong there, skip the ctrl-g step. Insert a module, put her there.

Still, you could post this procedure. ;)
 
Upvote 0

Forum statistics

Threads
1,212,149
Messages
6,106,250
Members
448,010
Latest member
wbarkwell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top