ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Control Tab (https://www.excelbanter.com/excel-discussion-misc-queries/259543-format-control-tab.html)

Gavin
Format Control Tab
 
In Excel 2000 there is no "Format Control Tab" only "Size, Protection,
Properties and Web" tabs to choose from after clicking on "Control
Properties" when attempting to format a SPIN BUTTON. How do I invoke this
missing tab?

Jim Thomlinson
Format Control Tab
 
Sounds to me like you grabbed the spinner off of the control toolbox an not
the forms toolbar. The controls from the Control Toolbox are ActiveX controls
and behave a bit differently. Their properties are accessed by right clicking
the control and selecting Properties instead of Format Control...
--
HTH...

Jim Thomlinson


"Gavin" wrote:

In Excel 2000 there is no "Format Control Tab" only "Size, Protection,
Properties and Web" tabs to choose from after clicking on "Control
Properties" when attempting to format a SPIN BUTTON. How do I invoke this
missing tab?


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com