-
L.S. I would like the code for a button like the Paste button in the Clipboard Group on the Home tab. A button which you can click but also with extra options in a drop down. Can someone please hint me in the good direction thnx
-
I have about 20 macros on an Excel 2007 spreadsheet. I have added buttons into the QAT. Unlike Office 97 - the buttons aren't labelled and the design of each button is limited to the choice of 180 available. You would think this was enough, but it isn't . What happened to the ability to design...
-
Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...
-
Was just upgraded to Excel2007 from Excel 2003. When I try to print any file created in Excel 2003 that has a pic/text box/ chart or any other object in the workbook it prints out of alignment(pics on text, text box/pics in different locations. It looks fine on the screen but when you print or print...
-
I originally recorded this macro several years ago using 2002-2003. The purpose was a menu pick to go to a sheet and print and return to another sheet. The printout produced about 150 rows of data over 10 pages. When I use this same VBA code Excel 2007, it stops at approximately row 100. Any ideas why...
-
I need to disable or hide the Minimize and restore/maximise control buttons on the Excel 2007 Window and ensure that window is always in full screen display. With VBA code disabling ESCAPE key plus related subroutine, the workbook is always maximised and its title bar is not visible. Also is it possible...
-
Hi, I got a problem in extracting the data while comparing 2 columns in excel. I have 2 columns say A and B. A has got list of names and B has got list of the same names with the address. All i need is to compare A & B and extract only the names of A in a new column C. Let me give an example. A B...
-
Since Office 2007 SP2 when an excel document is opened inside IE, an empty excel workspace is also opened outside ie. Is there a solution to avoid this ? This did not occur before SP2. Thank your for your help LG
-
I'm using Excel 2007. The program will not print to an HP Deskjet D2560. A sheet of paper goes through the printer, but it is blank. Excel prints to my Ricoh AP410 laser with no problems. Any suggestions?
-
Yes, that's what I do to. I adjust the column width and get reasonable alighment. Must be a bug in the program!! I also experience the problem that when I'm in page layout, I can't always select a singe cell. The program selects a group of cells or rows when I click a cell. It drives me crasy...