Apr 27, 2005 This package updates two Microsoft Visual Basic 6.0 Common Controls: mscomctl.ocx and comctl32.ocx to address the issues described in the KB articles noted in the Related Resources section on this page. Download MSCOMCT2.cab (it's. Microsoft Monthview Control 6.0 (SP6)'. Regards Deepak We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets.
When you highlight the section to copy and then go to the new workbook both the paste and paste special are 'grayed out'. This is true whether you right-click the mouse, go to the edit menu, or use control keys. This occurs with any data type and the most simple workbooks. I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the.xlb files and neither helps. You can open the clipboard and the paste will work, but there is no paste special option.
Any help would be greatly appreciated. Thought I'd append my experience of the above problem - you can find all sorts of references to it everywhere. My problem was that a userform defined with Excel at work (containing DT pickers) gave the message in the title when opening it at home. I had a light-bulb moment and wondered whether there was a difference in the version numbers for MSCOMCT2.OCX at work and at home. Turned out the work version was newer.
I then copied the MSCOMCT2. files from work, made a backup of them at home and copied those from work to my C-drive (Windows XP - c: windows system32 ). I then rebooted the machine - still no luck.
Then, finally I unregistered the old DLL via Code: regsvr32 /u c: windows system32 MSCOMCT2.OCX (not sure if this was necessary, but I didn't think it could hurt). Reregistered the DLL via Code: regsvr32 c: windows system32 MSCOMCT2.OCX and what do you know - it worked. Summa summarum - it could be an idea to check whether the two machines have different version numbers for the MSCOMCT2.OCX files. I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. So I removed the form control buttons and created new ActiveX command buttons.
I got into the button properties and set the background colors. I added the Click code to run the macros when the user clicked the buttons.
All of the buttons were working fine. Then I saved and closed the workbook and went to lunch. Now when I open the workbook, the buttons don't work! When I click them nothing happens.
They appear frozen. They don't even seem to click. No error message. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. I can't seem to locate the command button properties any longer. I still see the button name 'cmdButtonGetInfo' and '=EMBED('Forms.CommandButton.1',') in the name box and formula bar.
The odd thing is if I create a new button it works fine until I save and close the file. When I reopen the file none of the buttons work.
It's like the buttons are being disabled when I close or open the file. Any suggestions? I have a co-worker's file that he is having trouble with. He is using Excel 2000 SP3. When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'.
Example: A1: 50 A2: 10 B1: 60 B2: 20 A3: Formula: =A1+A2 Displays: 60 Right click A3, Copy, right click B3, paste A3 displays 60 When I click save, it will change the display value to 80. I am trying this on his workstation and mine. Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value.
I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this? I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. I have a file that has 8 sheets.
The first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours. The days of the week consists of 'Name' 'Date' Hours' The 8th sheet consists of 'Name', 'Days of the week in their own column (7 columns in total)', 'Total Hours' and 'Total Days Worked' Now. Each day is always a different group and what I'm hoping for is to create a formula that can grab each name with their hours and throw them into the 8th sheet. So when the end of the week is done I have all the Employees weekly hours and days worked all finished. I hope this makes sense. This file is to track about 100 employees that are on a rotational work schedule.
I have attached a sample file. Thanks in advance for your help. Hi Excel experts, I am working on a worksheet, and would like to have an entire row transferred to another worksheet based upon a certain cell's value.
Having searched through the many solved threads on this site, I attempted to customize some of the code to my worksheet. Not being proficient in Macro/VBA, I failed.
I figured I would ask for help, and see if anyone can provide what I am looking for. Basically, I am attempting to construct a 'work in process' file, and would like all completed work to be deleted from the work in process sheet, and transferred to a sheet that contains a running list of all work completed. Attached is an example of what I am working on. I would like Column Q (Status) to determine if a row can be moved to a sheet that contains the list of all work completed, and eliminated from the original sheet.
Once Status is updated to 'Complete', it would be helpful to be able to run a macro/click a button that would perform the transfer. Can anyone assist?
Hello, I am new to using Excel and I am not very computer literate. I am looking for some help with a spreadsheet I am making. Here is the problem: I have a column of 14 numbers in cells A1 to A14.
If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1. I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. For example, I have entered =IF(A1.
I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a.csv file in order to upload to an application that parses out the.csv data as transactions.
The system requires.csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good.
But I have to save as a.csv. So if I do that, close the Excel window, and then open again (as the.csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file.
But again, the second I save as.csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file?
Thanks so much for your help! I have searched and read all the help files.
I find the properties of an object, I see how I can 'lock', 'size and move with cells' or 'not move with cells'. No matter what I select, the object moves off the screen, when the user, scrolls to the right of the spreadsheet. Is there a way to lock the position, let's say, in the upper right corner and have it stay there? This would be quite useful for an EXIT button, that I have created, that will close the program without saving (it's a read-only file.) Thanks to all the wonderful people here that have been so helpful and give us their valuable insight and time.
Is there an Excel guru that can help with this - its related to 'drop down menus' I have 2 colombs of data. AT the bottom of the first, I have created a drop down menu using the 'data validation' feature in excel. At the bottom of the second colomb, I have used an 'IF' function that returns a result, which depends on what value is chosen from the drop down menu in colomb 1 The problem I have is that I want the TRUE result from the IF function to be another drop down menu, being the data in colomb 2. How do you write an IF function where the TRUE result is a drop down menu?? I tried to create a drop down menu of colomb2 elsewhere in the spread sheet, and used that cells location as the TRUE value, but this didn't work either.
ANy suggestions?? Is it possible to apply a filter to multiple sheets within the same Excel workbook, using the same filter criteria? For example, suppose you have tables of data on 3 different tabs, all having the same headings. Suppose one of the headings is 'gender'. If you apply a filter to the table on Sheet 1, to only show the rows containing the word 'female', is it possible to have the tables on Sheets 2 and 3 automatically update to only show the 'female' rows? Or would you have to manually update the filter criteria in Sheets 2 and 3? I hope this makes sense.
Thank you in advance for any help. Hello everyone, I am new to this forum and have been using excel for about 3 years. I have learned alot but still can not figure out how to make numbers add up in one box like a running total.
Meaning, If I have a list and in the list is one cell for each item say like cell a1 is for a can of coke and cell a2 is for a car tire and so on,and i want to keep a running total by adding a number to cell a1 or a2 like say '3 i.e. 3 tires or cans of coke' and later that day i come back and need to add 2 more.so i want to be able to just click on the cell a1 or a2 and enter the number 2 and the cell would add the number in it to the number im adding to it to show a result of 5 tires or whatever. I am sorry If i am not asking the question in an understandable manor but its the best way I can think to ask it.lol anyways, any help would be appreciated, Thanks in advance.
I have cells in a column, some colored yellow, some not. I am trying to use the SUMIF function to sum only the cells in the range that are colored. Can this be done?
Can I enter something in the 'criteria' part of the formula that can do this? =SUMIF(D3:D13,'criteria',D3:D13) I also tried to use the CELL function's color feature, but I couldn't get it to work right. I don't know how to get Excel to recognize if a cell is colored in a formula. =CELL('color',cell) It might just be that I don't know what this means in Help: 'color' - 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero). Can anyone help? Hi everyone, I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell.
This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list. The macro works perfectly for my purposes except in one regard: I can no longer perform a 'show all' filter. If I leave the 'search bar' cell blank, the pivot table shows nothing. I'm sure that there is an easy fix for this but I'm still learning the basics of how to write and use macros.
How can I change the code so that when I leave the cell blank, the pivot table shows all? The search bar cell is D2. Thanks for your time!
KB Articles:. This package updates two Microsoft Visual Basic 6.0 Common Controls: mscomctl.ocx and comctl32.ocx to address the issues described in the KB articles noted in the Related Resources section on this page. This package will not install these Common Controls if they do not already exist on the target system. This package cannot be uninstalled. This package is provided under the terms of the End User License Agreement and is intended for the following customers:.
Customers who are Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 licensees. Customers who are not licensees of Microsoft Visual Basic 6.0 nor Microsoft Visual Studio 6.0 but are using older versions of the two Common Controls. Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. However, we are releasing this non-security related package because it contains improvements that were ready for release just prior to the end of Mainstream Support. Microsoft Visual Basic 6.0 has transitioned to Extended Support which runs through March 31, 2008.
Microsoft is not extending the Mainstream Support phase for Microsoft Visual Basic 6.0 in any way.