Calendar in Excel shrinks

Question

Hi, I am using Excel VBA. I added a calendar control so that users can pick the date from the calendar. I noticed something that whenever the excel file is opened the Calendar shrinks smaller and smaller. Now I can see that the calendar will disappear after reopening the file several times. Any ideas? please help Thanks,

Answer 1

I've seen this behaviour before with other controls. I think it's a bug that is linked to the control's resize setting, even though cells aren't being resized.

Try the following in design mode:

• Right-click control and select Format Control
• In Properties tab, select 'Don't move or size with cells'

Answer 2

Thanks for replying. I checked that, but it is already selected as " Don't move or size with cells" Is there anything else might be the reason? it is strange.