+ Reply to Thread
Results 1 to 11 of 11

Unvisible checkbox

Hybrid View

Guest Unvisible checkbox 08-21-2006, 03:50 AM
Guest Re: Unvisible checkbox 08-21-2006, 04:15 AM
Guest Re: Unvisible checkbox 08-21-2006, 05:20 AM
Guest Re: Unvisible checkbox 08-21-2006, 05:20 AM
Guest Re: Unvisible checkbox 08-21-2006, 05:20 AM
Guest Re: Unvisible checkbox 08-21-2006, 05:20 AM
  1. #1
    Madiya
    Guest

    Unvisible checkbox

    I am adding few checkboxes directly to the worksheet cell by toolbar
    (control toolbox).
    I have set the enable and visible property to true but still the
    checkboxes are not visible.
    I intend to assign a macro to each checkbox to carry out some
    operations.

    I have done it earlier but now cant figure out how to make it visible
    permanantly.

    Pl help.
    Regards,
    Madiya


  2. #2
    Norman Jones
    Guest

    Re: Unvisible checkbox

    Hi Madiya,

    The default values for the checkbox's Visible and Enabled properties is
    true.

    However, the following works for me:

    '=============>>
    Public Sub Tester()
    Dim SH As Worksheet

    Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE

    With SH.OLEObjects("Checkbox1")
    .Visible = True
    .Enabled = True
    End With

    End Sub
    '<<=============

    Post your problematic code.


    ---
    Regards,
    Norman



    "Madiya" <madiya122@yahoo.co.uk> wrote in message
    news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    >I am adding few checkboxes directly to the worksheet cell by toolbar
    > (control toolbox).
    > I have set the enable and visible property to true but still the
    > checkboxes are not visible.
    > I intend to assign a macro to each checkbox to carry out some
    > operations.
    >
    > I have done it earlier but now cant figure out how to make it visible
    > permanantly.
    >
    > Pl help.
    > Regards,
    > Madiya
    >




  3. #3
    Madiya
    Guest

    Re: Unvisible checkbox

    Hi Norman,
    I have run your code but still checkboxes are not visible.

    So far I have not written any code. I belive writing a simple code will
    not be a problem once I make the checkbox visible. Code is a macro
    derived from a macro recorder. It works fine if I run frirectly from
    run Macro.

    My only problem is checkboxes are not visible.
    Regards,
    Madiya

    Norman Jones wrote:
    > Hi Madiya,
    >
    > The default values for the checkbox's Visible and Enabled properties is
    > true.
    >
    > However, the following works for me:
    >
    > '=============>>
    > Public Sub Tester()
    > Dim SH As Worksheet
    >
    > Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE
    >
    > With SH.OLEObjects("Checkbox1")
    > .Visible = True
    > .Enabled = True
    > End With
    >
    > End Sub
    > '<<=============
    >
    > Post your problematic code.
    >
    >
    > ---
    > Regards,
    > Norman
    >
    >
    >
    > "Madiya" <madiya122@yahoo.co.uk> wrote in message
    > news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    > >I am adding few checkboxes directly to the worksheet cell by toolbar
    > > (control toolbox).
    > > I have set the enable and visible property to true but still the
    > > checkboxes are not visible.
    > > I intend to assign a macro to each checkbox to carry out some
    > > operations.
    > >
    > > I have done it earlier but now cant figure out how to make it visible
    > > permanantly.
    > >
    > > Pl help.
    > > Regards,
    > > Madiya
    > >



  4. #4
    Norman Jones
    Guest

    Re: Unvisible checkbox

    Hi Madiya,

    (1) Are you sure that the checkboxes are on sheet1?
    (2) Are you sure that you are using the correct Checkbox name?
    (3) How did you hide them?


    ---
    Regards,
    Norman



    "Madiya" <madiya122@yahoo.co.uk> wrote in message
    news:1156149220.132972.181230@m79g2000cwm.googlegroups.com...
    > Hi Norman,
    > I have run your code but still checkboxes are not visible.
    >
    > So far I have not written any code. I belive writing a simple code will
    > not be a problem once I make the checkbox visible. Code is a macro
    > derived from a macro recorder. It works fine if I run frirectly from
    > run Macro.
    >
    > My only problem is checkboxes are not visible.
    > Regards,
    > Madiya
    >
    > Norman Jones wrote:
    >> Hi Madiya,
    >>
    >> The default values for the checkbox's Visible and Enabled properties is
    >> true.
    >>
    >> However, the following works for me:
    >>
    >> '=============>>
    >> Public Sub Tester()
    >> Dim SH As Worksheet
    >>
    >> Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE
    >>
    >> With SH.OLEObjects("Checkbox1")
    >> .Visible = True
    >> .Enabled = True
    >> End With
    >>
    >> End Sub
    >> '<<=============
    >>
    >> Post your problematic code.
    >>
    >>
    >> ---
    >> Regards,
    >> Norman
    >>
    >>
    >>
    >> "Madiya" <madiya122@yahoo.co.uk> wrote in message
    >> news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    >> >I am adding few checkboxes directly to the worksheet cell by toolbar
    >> > (control toolbox).
    >> > I have set the enable and visible property to true but still the
    >> > checkboxes are not visible.
    >> > I intend to assign a macro to each checkbox to carry out some
    >> > operations.
    >> >
    >> > I have done it earlier but now cant figure out how to make it visible
    >> > permanantly.
    >> >
    >> > Pl help.
    >> > Regards,
    >> > Madiya
    >> >

    >




  5. #5
    NickHK
    Guest

    Re: Unvisible checkbox

    Madiya,
    When you place new control on a worksheet, Excel changes to Design mode.
    In design mode, all controls are visible, even if their .Visible has been
    set to False
    So if you add any control to the worksheet, all controls will become
    visible.
    If you still do not see your checkboxes, then there are no check boxes on
    that sheet.
    May be you added them to another sheet, or placed them a long way from A1.

    NickHK

    "Madiya" <madiya122@yahoo.co.uk> wrote in message
    news:1156149220.132972.181230@m79g2000cwm.googlegroups.com...
    > Hi Norman,
    > I have run your code but still checkboxes are not visible.
    >
    > So far I have not written any code. I belive writing a simple code will
    > not be a problem once I make the checkbox visible. Code is a macro
    > derived from a macro recorder. It works fine if I run frirectly from
    > run Macro.
    >
    > My only problem is checkboxes are not visible.
    > Regards,
    > Madiya
    >
    > Norman Jones wrote:
    > > Hi Madiya,
    > >
    > > The default values for the checkbox's Visible and Enabled properties is
    > > true.
    > >
    > > However, the following works for me:
    > >
    > > '=============>>
    > > Public Sub Tester()
    > > Dim SH As Worksheet
    > >
    > > Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE
    > >
    > > With SH.OLEObjects("Checkbox1")
    > > .Visible = True
    > > .Enabled = True
    > > End With
    > >
    > > End Sub
    > > '<<=============
    > >
    > > Post your problematic code.
    > >
    > >
    > > ---
    > > Regards,
    > > Norman
    > >
    > >
    > >
    > > "Madiya" <madiya122@yahoo.co.uk> wrote in message
    > > news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    > > >I am adding few checkboxes directly to the worksheet cell by toolbar
    > > > (control toolbox).
    > > > I have set the enable and visible property to true but still the
    > > > checkboxes are not visible.
    > > > I intend to assign a macro to each checkbox to carry out some
    > > > operations.
    > > >
    > > > I have done it earlier but now cant figure out how to make it visible
    > > > permanantly.
    > > >
    > > > Pl help.
    > > > Regards,
    > > > Madiya
    > > >

    >




  6. #6
    Madiya
    Guest

    Re: Unvisible checkbox

    Hi Norman,
    Checkbox are on sheet1, name is default name (checkbox1).
    I have nover tried to hide it. Whenever I add any checkbox on sheet1(
    or any other sheet for that matter, it hides itself.

    Hi NickHK,
    I open a new workbook and on sheet1, I added a checkbox.
    When I exited design mode box is not visible. I entered in design mode,
    box is not visible. Since I know the location, I moved my mouse on the
    same and when mouse chenged, I clicked, box is there and shows only
    four corners.

    Its so strange!!!

    Regards,
    Madiya.


    NickHK wrote:
    > Madiya,
    > When you place new control on a worksheet, Excel changes to Design mode.
    > In design mode, all controls are visible, even if their .Visible has been
    > set to False
    > So if you add any control to the worksheet, all controls will become
    > visible.
    > If you still do not see your checkboxes, then there are no check boxes on
    > that sheet.
    > May be you added them to another sheet, or placed them a long way from A1.
    >
    > NickHK
    >
    > "Madiya" <madiya122@yahoo.co.uk> wrote in message
    > news:1156149220.132972.181230@m79g2000cwm.googlegroups.com...
    > > Hi Norman,
    > > I have run your code but still checkboxes are not visible.
    > >
    > > So far I have not written any code. I belive writing a simple code will
    > > not be a problem once I make the checkbox visible. Code is a macro
    > > derived from a macro recorder. It works fine if I run frirectly from
    > > run Macro.
    > >
    > > My only problem is checkboxes are not visible.
    > > Regards,
    > > Madiya
    > >
    > > Norman Jones wrote:
    > > > Hi Madiya,
    > > >
    > > > The default values for the checkbox's Visible and Enabled properties is
    > > > true.
    > > >
    > > > However, the following works for me:
    > > >
    > > > '=============>>
    > > > Public Sub Tester()
    > > > Dim SH As Worksheet
    > > >
    > > > Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE
    > > >
    > > > With SH.OLEObjects("Checkbox1")
    > > > .Visible = True
    > > > .Enabled = True
    > > > End With
    > > >
    > > > End Sub
    > > > '<<=============
    > > >
    > > > Post your problematic code.
    > > >
    > > >
    > > > ---
    > > > Regards,
    > > > Norman
    > > >
    > > >
    > > >
    > > > "Madiya" <madiya122@yahoo.co.uk> wrote in message
    > > > news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    > > > >I am adding few checkboxes directly to the worksheet cell by toolbar
    > > > > (control toolbox).
    > > > > I have set the enable and visible property to true but still the
    > > > > checkboxes are not visible.
    > > > > I intend to assign a macro to each checkbox to carry out some
    > > > > operations.
    > > > >
    > > > > I have done it earlier but now cant figure out how to make it visible
    > > > > permanantly.
    > > > >
    > > > > Pl help.
    > > > > Regards,
    > > > > Madiya
    > > > >

    > >



  7. #7
    Norman Jones
    Guest

    Re: Unvisible checkbox

    Hi Madiya,

    I would try closing Excel, rebooting your PC and then deleting the contents
    of your
    Temp directory.

    To easily open the Temp folder, try:

    Windows | Start | Run | %temp%

    Now re-open your file.

    If you still experience problems, I would suspect possible corruption. In
    this case, try opening a new, virgin file and insert a checkbox. If the new
    checkbox is visible, I would try rebuilding your file.


    ---
    Regards,
    Norman



    "Madiya" <madiya122@yahoo.co.uk> wrote in message
    news:1156150845.225363.81480@74g2000cwt.googlegroups.com...
    > Hi Norman,
    > Checkbox are on sheet1, name is default name (checkbox1).
    > I have nover tried to hide it. Whenever I add any checkbox on sheet1(
    > or any other sheet for that matter, it hides itself.
    >
    > Hi NickHK,
    > I open a new workbook and on sheet1, I added a checkbox.
    > When I exited design mode box is not visible. I entered in design mode,
    > box is not visible. Since I know the location, I moved my mouse on the
    > same and when mouse chenged, I clicked, box is there and shows only
    > four corners.
    >
    > Its so strange!!!
    >
    > Regards,
    > Madiya.
    >
    >
    > NickHK wrote:
    >> Madiya,
    >> When you place new control on a worksheet, Excel changes to Design mode.
    >> In design mode, all controls are visible, even if their .Visible has been
    >> set to False
    >> So if you add any control to the worksheet, all controls will become
    >> visible.
    >> If you still do not see your checkboxes, then there are no check boxes on
    >> that sheet.
    >> May be you added them to another sheet, or placed them a long way from
    >> A1.
    >>
    >> NickHK
    >>
    >> "Madiya" <madiya122@yahoo.co.uk> wrote in message
    >> news:1156149220.132972.181230@m79g2000cwm.googlegroups.com...
    >> > Hi Norman,
    >> > I have run your code but still checkboxes are not visible.
    >> >
    >> > So far I have not written any code. I belive writing a simple code will
    >> > not be a problem once I make the checkbox visible. Code is a macro
    >> > derived from a macro recorder. It works fine if I run frirectly from
    >> > run Macro.
    >> >
    >> > My only problem is checkboxes are not visible.
    >> > Regards,
    >> > Madiya
    >> >
    >> > Norman Jones wrote:
    >> > > Hi Madiya,
    >> > >
    >> > > The default values for the checkbox's Visible and Enabled properties
    >> > > is
    >> > > true.
    >> > >
    >> > > However, the following works for me:
    >> > >
    >> > > '=============>>
    >> > > Public Sub Tester()
    >> > > Dim SH As Worksheet
    >> > >
    >> > > Set SH = ThisWorkbook.Sheets("Sheet1") '<<=== CHANGE
    >> > >
    >> > > With SH.OLEObjects("Checkbox1")
    >> > > .Visible = True
    >> > > .Enabled = True
    >> > > End With
    >> > >
    >> > > End Sub
    >> > > '<<=============
    >> > >
    >> > > Post your problematic code.
    >> > >
    >> > >
    >> > > ---
    >> > > Regards,
    >> > > Norman
    >> > >
    >> > >
    >> > >
    >> > > "Madiya" <madiya122@yahoo.co.uk> wrote in message
    >> > > news:1156146294.280722.223450@h48g2000cwc.googlegroups.com...
    >> > > >I am adding few checkboxes directly to the worksheet cell by toolbar
    >> > > > (control toolbox).
    >> > > > I have set the enable and visible property to true but still the
    >> > > > checkboxes are not visible.
    >> > > > I intend to assign a macro to each checkbox to carry out some
    >> > > > operations.
    >> > > >
    >> > > > I have done it earlier but now cant figure out how to make it
    >> > > > visible
    >> > > > permanantly.
    >> > > >
    >> > > > Pl help.
    >> > > > Regards,
    >> > > > Madiya
    >> > > >
    >> >

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1