General discussion

Locked

XL97 - Spin Button Control Tab Missing

By Chouf ·
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?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

XL97 - Spin Button Control Tab Missing

by DKlippert In reply to XL97 - Spin Button Contro ...

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.

Collapse -

XL97 - Spin Button Control Tab Missing

by Chouf In reply to XL97 - Spin Button Contro ...

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...

Collapse -

XL97 - Spin Button Control Tab Missing

by DKlippert In reply to XL97 - Spin Button Contro ...

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

Collapse -

XL97 - Spin Button Control Tab Missing

by Chouf In reply to XL97 - Spin Button Contro ...

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.

Collapse -

XL97 - Spin Button Control Tab Missing

by Chouf In reply to XL97 - Spin Button Contro ...

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 ...

Collapse -

XL97 - Spin Button Control Tab Missing

by Chouf In reply to XL97 - Spin Button Contro ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums