Show Sum, Count, ect in customized status bar

[jrabi]

I have sum and count checked when I right click in the customized status bar, but cannot see in the status bar?

How can I get this to show up?

 

[jrabi]

I copied this code into the intermediate window and it works, not sure why it did not work originally?

Application.CommandBars("Status Bar").Visible =3D True 'Show<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Application.CommandBars("Status Bar").Visible =3D False 'Hide<o></o>


Any thoughts?

 

[Nalani]

It seems that your Status Bar was set to False somewhere along the lines.

You may have code that was running somewhere that turned it off.

Either way, try this
1. Alt F11 to open VBE
2. Alt G to open Immediate Window
3. Type in Application.DisplayStatusBar = True
4. Hit Enter

Hope that helps

 

[Nalani]

Just seen your post after I posted.

I think that is where your problem lies. It is turning it OFF

 

[jrabi]

Its weird because only one function shows while the others do not show in the status bar, example count shows but sum and max are checked.


The codes work.

Do you know where/how to turn this function on? Or does it have to be done with code?

Seems odd....maybe re-install will solve issue, not sure?

 

[Nalani]

I copied this code into the intermediate window and it works, not sure why it did not work originally?

Application.CommandBars("Status Bar").Visible =3D True 'Show<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Application.CommandBars("Status Bar").Visible =3D False 'Hide

Indicates that you "might have" copied from some code module you have.

If so, could you post the whole code. There may lie the answer.

Possible that one of the Options is turned off through your code.

 

[jrabi]

No, I found this online and copied these two lines into the intermediate window, the status bar works fine now with the code....

I was wondering if there was a way to turn it on and off for example in excel options, looked could not find.

You should not have to write code to get a status bar to work right?

 

[Nalani]

As far as I know..There is no way to turn it Off and On in Options.

But if it is being turned Off......... Then what I'm saying is you "May" have a piece of code that is doing it.

Only you know since, only you know what code is in your project.

 

[Nalani]

Just to reinterate:

Its weird because only one function shows while the others do not show in the status bar, example count shows but sum and max are checked.

Once you Right click and setup your Status bar, it should display what you checked.

Do you have any code that you run that may have lines that set Sum and Max to False?

 

[jrabi]

Understood. I re-installed and it works fine, I think it was a bug, but it could have been some code like you say, but it works now without any additional code so not sure. I did just have excel 2007 installed on my computer because of a rebuild on Monday of this week. We may never know about this one.........

Thanks for the insight.