Software

Ask something
Discussion Locked

XL97 - Spin Button Control Tab Missing

0 helpful
6 replies

by chouf

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have to deal with a weird problem.

A user running OFF97 Pro SR2b with W2K SP2 is missing a tab in Excel 97.

When you insert "spin buttons" from the Forms toolbar, you can normally right-click them to access the Format options. Once in the Format window, there's a tab called Control in which you can specify the min and max values as well as the linked cell, etc... Unfortunately, on that machine, the Control tab is missing ! She has the 3 first tabs, but no Control tab. Then she cannot set the spin buttons' properties as she would like to.
I already searched a bit on TechNet but didn't find anything relevant. I uninstalled and renstalled the whole Office package and re-applied the SR2. This occurs for any document. She has full admin rights on her machine.
Any idea plz?

6 replies

by dklippert

Make sure she is using the Form toolbar not the Control toolbar. The Control tab will not be shown if the Control toolbar is used.

by chouf

Thanks for your quick answer, but actually I'm sure we used the Forms toolbar, because that Forms toolbar wasn't displayed on her machine; so I explicitly had to go in View > Toolbars > Forms to access the 'spin button' button.
The other thing that let me know we're doing it the same way is that on my machine (same config as same template) the exact same procedure is working fine and I do have access to the Control tab...

by dklippert

Try it again. Put in one spinner from the Form toolbar and one from the Control toolbar then see which has the Control tab

by chouf

Well, hmmmm even though it's hard to admit it, you were right. She was using the Control toolbar instead of the Forms one. With the Forms toolbar, no problem at all, we cal set all the prefs we need.
Thanks a lot.

by chouf

OK I'll try that and get back to you. Thanks for you help ! It's really appreciated. By the way the "Last Save Time" in XL solution you gave me the other day works now ...

This discussion is closed to new replies.