when a button on the spreadsheet is pressed, i get what's shown above. i sent the same spreadsheet to my coworkers and the buttons work fine.

i have the same things installed and same settings as my coworker.

i did not create this xls, it was taken from a template db.

thoughts?

 

Any ideas?

I repaired Office, updated video drivers, and downloaded the latest hotfixes and it is still doing it.

 

have you tried removing office and re-installing it?

 

I have no idea. Do you know how to work with Macros? Is the button directed toward the correct function in the macro?

 

i did the repair from Add/Remove Programs


uninstalling would require new license.

 

It's personal. It just doesn't like you.





I really don't know. Sorry I can't be much help, but it looks like it's trying to open an object or perform a function that is not on your system. Find out what it's pointing to on a machine that it does work on then search for that object on yours.

There's nothing wrong with Office or Excel. It's trying to call something that doesn't exist. At least not on your system anyway.

 

^Yeah, that's what I was thinking...what is clicking the object button supposed to cause to happen?

 

this is what it should look like when a button is pushed. it's not really a function, just a help statement.
not sure what you mean by searching for the object.


each button has a different statement.

 

I'd guess something's wrong the with actual vb code because that's about as simple of a command as you can get (push button, window pops up). Now why it works for some people and not you, I have no idea. Maybe it's as Shalooby was alluding to: that the object, in this case the text in the box, is somewhere else? I would think it's in the code, but I guess it's possible that it's pulling it from an outside source. Got a screen shot of the code for the button?

 

Are you getting the macro warning when you open the file, I think the default excel security setting is to restrict them. Look at the actual macro setup "step into" button, that will show the code behind the macro, it might be pointing to a cell that has the text that is supposed to appear.

 

 

i get the warning and select "enable macros"
i can't change the settings as work has them defaulted to medium

 

You need to determine where those objects are (ex. GuidanceFA3).

 

Guidance FA3 is just the name of the button, no?

find the objects--what the buttons are referencing?

 

No, the button is CommandButtonFA3; when you click on it, it's supposed to show GuidanceFA3, which is something that's somewhere else. Looking at your screenshot, I'd guess it's one of the forms in the Forms folder.

 

LOL, I have an excel question too: does any one know how I can add the $ sign in front of numbers in every single column? like the formula or whatever code it is. cause I don't want to manually enter it for 1000+ cells.

 

compared the code from the forms folder with the folder on the working computer, and all is identical.

i compared the security setting in my excel w/ the working excel and they are the same. the only thing i can think of is, there must be something on my computer blocking the vbscript.

 

Highlight all, right click, format as currency.

 

LOL, awesome. thanks.

 

Might be a video card driver problem.

Try rebooting first.

If that doesn't solve your problem, try updating the driver and try again.

 

as a test, you could try logging into your computer under a different profile/or create a new profile and see if it still happens

 

post #2



i tried safe mode, diagnostic start up, and selective start up (disabled everything). i know that's different than what you suggest.
the PCs are imaged w/ one profile and it's a PITA to jump thru the hoops of getting another one put on the computer.

 

The code on both computers is going to be the same. What you need to look for is the object or function that the code is calling, then see if that object or function is present on your system.

The code is working fine. You press a button and it is attempting to do something by calling something else. It is the "something else" that is missing which is the problem.

 

Call Level 3?

 

do you know the admin password? all xp machines have a default profile typically and the administrator account . so if you have the admin password, try the administrator account.

 

In each of the click methods before GuidanceFA(number).Show, where (number) is one of the help forms, add this line:

guidanceFA(number).BackColor = &HFFFFFF

That should change the background color to white. It might be using a system color that you have set to black on your system, but other computers don't.

 

Still does the same thing.




escalated.....


i'll update if they have a fix.

thanks for all the help!

 

If it's not confidential or if it's just a template, you can send it my way and I'll check out the VBA code.

 

Try this:

Right click on your desktop background (not in Excel) and select "Properties" to get into the "Display Properties".
Click on "Appearance".
Under "Color Scheme", select "Default (blue)".
Click "OK".

 

most excellent. that worked!!!!
i never would have guessed that.
looking back at this thread, i see how you came up with that.

i wish i could remember that saying, something about the simplest answer.

i'll have to wait until tuesday to see if the people i escalated to can come up w/ an answer.

muchas gracias!
vielen dank!

 

Glad it worked!

Yup, Anachostic's post made me think of the solution!

 

ya and the screenshot i posted that worked was blue color scheme and the one that didnt work were silver.