Replies

>If you use GoTo, Special…, Objects, then press Delete, this should delete all objects, even if you can’t see them.

Hans – this gets rid of all objects on the sheet – except for the calendar control in cell E7 which I can’t see.

No – I do not think so. I believe I have either acorrupted sheet or a hidden calendar control that I can not get rid of.

No – I do not think so. I believe I have either acorrupted sheet or a hidden calendar control that I can not get rid of.

Hans – thanks again. No – the worksheet does not contain a user form with a calendar control. I wish it was that simple. You may have seen my message under Post 315082 as I was trying to run the code to resize objects and I could not get the code to work. Your macro does identify that there is an object or a shape in cell E7 on the worksheet but I cannot see it. Even if I press F5 and go to special, objects, that does not highlight it either. This is certainly frustrating.

Hans – thanks again. No – the worksheet does not contain a user form with a calendar control. I wish it was that simple. You may have seen my message under Post 315082 as I was trying to run the code to resize objects and I could not get the code to work. Your macro does identify that there is an object or a shape in cell E7 on the worksheet but I cannot see it. Even if I press F5 and go to special, objects, that does not highlight it either. This is certainly frustrating.

I am trying to use this code to resize a control that is hidden on a worksheet (so I can locate it and kill it). The code that Hans provided shows the position of this control as $E$7 (although I cannot see it). When I run this code to try to resize it, I get an error with Shp.select (method of object ‘shape’ failed). I did insert a Dim statement to dim shp as shape. Any idea why the code is not running?

I am trying to use this code to resize a control that is hidden on a worksheet (so I can locate it and kill it). The code that Hans provided shows the position of this control as $E$7 (although I cannot see it). When I run this code to try to resize it, I get an error with Shp.select (method of object ‘shape’ failed). I did insert a Dim statement to dim shp as shape. Any idea why the code is not running?

I think the workbook somehow has been corrupted. I already moved the one sheet where the calendar control object supposedly is located to a new, clean worksheet, but that did not seem to help. It eliminated the reference to calendar on the sheet objects list, but the user reported that the macros still would not function.

It will copy all of the other sheet to a new workbook and try again.

What did you mean about using the link provided earlier? Was this the message concerning the MSCAL.OCX file?

I think the workbook somehow has been corrupted. I already moved the one sheet where the calendar control object supposedly is located to a new, clean worksheet, but that did not seem to help. It eliminated the reference to calendar on the sheet objects list, but the user reported that the macros still would not function.

It will copy all of the other sheet to a new workbook and try again.

What did you mean about using the link provided earlier? Was this the message concerning the MSCAL.OCX file?

Thanks, Hans. If I am not using a calendar control anywhere in my project, why would Excel VBA complain about the absense of mscal.ocx?

Thanks, Hans. If I am not using a calendar control anywhere in my project, why would Excel VBA complain about the absense of mscal.ocx?

My system where the workbook was developed has Office Pro – but the PCs where the wrokbook will be used have Office Std. – i.e., no Access. Why should that be a problem?

Thanks.

My system where the workbook was developed has Office Pro – but the PCs where the wrokbook will be used have Office Std. – i.e., no Access. Why should that be a problem?

Thanks.

Hans – one other question: The object browser says that sheet 10 in my workbook contains a calendar control. But It doesn’t.. If I go to Sheet 10 under Excel Objects, I have (General), Calendar1, and Worksheet listed on the drop down list. How do I get rid of Calendar1 when there is no calendar contron on the worksheet. Excel apparently thinks there is – so how do I ‘unconfuse’ Excel?

Hans – one other question: The object browser says that sheet 10 in my workbook contains a calendar control. But It doesn’t.. If I go to Sheet 10 under Excel Objects, I have (General), Calendar1, and Worksheet listed on the drop down list. How do I get rid of Calendar1 when there is no calendar contron on the worksheet. Excel apparently thinks there is – so how do I ‘unconfuse’ Excel?