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,
A:
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'
Lunatik
2010-08-25 09:30:39
A:
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.
guest1
2010-08-25 14:21:25