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

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" wrote in message
oups.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

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" wrote in message
oups.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

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" wrote in message
oups.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" wrote in message
oups.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

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" wrote in message
oups.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" wrote in message
oups.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

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" wrote in message
oups.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" wrote in message
oups.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

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" wrote in message
ps.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" wrote in message
oups.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" wrote in message
oups.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