I have recently had to replace a work computer and reloaded Excel 2003 (now running on Windows 7). The monthview control in a file we use regularly is no longer there, and just displays as a big red "x". The monthview control is not listed under the "more controls" option, and I have downloaded mscomct2.ocx to my System 32 file, but it still does not show up as an option. Any suggestions?
Hi Jason and welcome to the forum,
I believe you had an active x control called MSCal which showed you the month in your old workbook. That has been discontinued. There is a rumor that it had some security issues. Microsoft now ships the DTPicker as their control of choice to replace this older control.
In the VBA editor you need to set a Reference to (check the box) next to Microsoft Windows Common Controls - 2.6.9 (SP6)
This will then allow the DTPicker control to be displayed in the VBA View Toolbox so you can add it to your Form or worksheet.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks