Re: Setting appearance of disabled Checkbox

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the neat solution.
Stan Hilliard

On Mon, 19 Jan 2009 15:53:21 -0500, "Rick Rothstein"
<rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote:
You could shrink the width of the CheckBox so that only the disabled check
box portion showed and place a Label next to the CheckBox to serve as the
caption.

--
Rick (MVP - Excel)


"Stan Hilliard" <usenetreplyMS@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:u8n9n41uruj2sh4oal0bpk64qjnpdkpmcu@xxxxxxxxxx
I have a checkbox for the purpose of indicating an unchangeable
setting. I want it to be always disabled, checked, and gray within the
square.

The problem is how to make the text black -- as it would be if the
checkbox were enabled. Right now the text is in the form of an
indentation -- like a frame border.

How can I make the text black as normal?
Stan Hilliard

.

Relevant Pages

  • RE: checkbox in Excel form
    ... One issue I am having with my code is, On my excel form, I have text boxes, ... clicks submit button(without filling up a mandatory field). ... Dim SumValue As Integer ... I have 6 checkboxes on an excel user form, ...
    (microsoft.public.excel.programming)
  • Do not send fonts to Distiller checkbox
    ... Within the Excel Print/Properties/Adobe PDF Settings/ ... The default for this checkbox ... Adobe Acrobat Professional 6.0 has checkbox 'checked'. ... to send the host fonts. ...
    (microsoft.public.excel.programming)
  • Re: Need report to only select the "yes" based on month
    ... Visio MVP ... "Hedwig14" wrote in message ... "John Spencer MVP" wrote: ... What do you want to happen if the checkbox is not checked? ...
    (microsoft.public.access.gettingstarted)
  • Trust VB projects setting Grayed out
    ... >I am working on some code that uses COM to manipulate VB code in Excel. ... > know that my users need to check the "Trust access to Visual Basic ... > checkbox in Excel's security settings in order to access VBProjects. ... I tried adding the value to my 10.0 registry key and it had effect. ...
    (microsoft.public.excel.programming)
  • Re: How to control checkbox results to show/hide Excel Worksheet tab
    ... I have an excel spreadsheet with a list of 45 ... > with a checkbox. ... Private Sub CheckBox1_Click ... ElseIf VisibleSheetCount> 1 Then ...
    (microsoft.public.vb.controls)