how to prevent that autocorrect "feature" in the Excel 2007 VBA IDE? It always deletes the last space I type after a second or so, i.e. moving the cursor to the left whenever I stop typing (to think for a moment or so).
View 9 RepliesI am using Excel 2007. I would like to be able to type "dlta" followed by a space and have autocorrect change it to the symbol for Delta (a triangle). I got it to work in Word because I could right click and paste the symbol in the autocorrect dialogue box. Excel won't let me do that. I also tried typing Alt+68 because I believe that is the code for the symbol I want but all I get is a "D".
View 11 Replies View RelatedI'm looking for a way to replace periods with colons using VB when a value is entered into a cell ranges. The ranges are
C4:L5
C9:L10
C14:L15
C19:L20
For info, this is an annual timesheet with 13 sheets in the workbook, each hosting 4 weeks of the year.
The cells are formatted as [h]:mm. Making an entry in the autocorrect table to replace . with : does exactly what I want. Unfortunately this is a global Excel setting rather than a single spreadsheet setting. I'm looking for a way to achieve the same using VB. Whenever a cell in this range on any sheet is modified I need that cell to be checked for periods and have them changed to colons.
In short (for example), I want to be able to enter 12.55 in a cell formatted as [h]:mm and have it autocorrect to 12:55 rather than enter a value of 301:12. Is this achievable without autocorrect?. It would need to only check the current cell been modified rather than scan all 4 ranges on all 13 sheets every time any cell is changed.
simply to say i want export and import all my "auto correct" words to other computer instead of typing manual...
Here some example am using daily ..
PLAN MISMATCH IN CPOS WITH CAFP 1
P2P NOT ELIGIBLE P 2
NEED CLARITY ON PLAN AND TOPPINGP 3
NEED CLARITY ON TOPPING P 4
NEED CLARITY ON RECEIPT AMOUNT AND RECEIPT NUMBERP 5
NEED PLAN APPROVAL P 6
if i type P1 in a cell it will show PLAN MISMATCH IN CPOS WITH CAF, i have like this many words. i want load it another one computer instead of adding manual typing. is it possible?
I need to make a formula which can take a date formatted cell 01/01/2007, and take only the 2007 and compare that to a cell with general format with the txt 2007. If I use =RIGHT(A1;4) i get the date serial rather than the year... how can I pull out only the 4 digit year..?
View 3 Replies View RelatedI've been sent a document by a client which has come with an add-in which has automatically installed itself into the Ribbon. It's on the Add-In tab (obviously!) and the Command Group is named 'Custom Toolbars'. What's annoying is once I close the document, the Add-In stays there and I have a redundant tab with an irrelevant Command Group .
Now, I've done a bit of searching and how found a number of websites that give instructions on add-ins. However, the add-in that has come with the client's document isn't on the list and hence I can't remove it. I need to do to get rid of this? I've contacted the client, but they're suspiciously quiet about the whole thing.
find attached a File that is a Part answer to a Thread. The problem is the code in sheet 1 ("Amend Test") Button, does not seem to run in 2007, only on earlier versions.
View 4 Replies View RelatedMy office converted to 2007 last night. I had created my own macro toolbar in 2003 with frequently used macros on it. How do I recreate this in 2007?
View 14 Replies View RelatedI have a piece of code that arranges a chart to fit the data it should show. The code used to work perfectly in the old Excel version, but after an "upgrade" to Excel 2007 I get "Automation Error" from the line where the scale type is set.
View 5 Replies View RelatedFormulas do not work now. Is there an updated version of the More Function for Excel 2007 that I need to get?
I've just had Office 2007 installed on my computer and I HATE the new Excel layout. Is there any way I can get the old look back - I liked the old customizable toolbars and I hate these new ribbons.
I know there's one customizable easy access toolbar. Is there a way I can get more toolbars and get rid of these dangblasted ribbons?
We have a large list of data with an autofilter on it. On column, R we want to show ONLY Blanks. Once we have the Blanks filtered, we put the word, TRADE (or any other word that you want). We finally select all the TRADE cell that were previously shown as blank and highlight them yellow. When we cancel the filter, all the rows in between are now highlighted yellow whereas in Excel 2003, only the rows that we highlighted when the filter was in place had the yellow highlighting.
There is a workaround that you can select each cell individually, apply a fill color, go onto the next cell, apply the color, etc but that is not efficient.
1. When I close the last open file, EXCEL stays open? why? what can be done?
2. When I open a workspace first after starting excel, the task bar does not show the files included. However, if I open another file first and then a workspace, all files are visible in the taskbar.
I am having trouble with the 2003 Alt keys in 2007 ..
I have 2 computers (work & home)
The work computer works fine ... when i use same files on home computer some alt key features wont work?
Example Alt E S T .... (paste special formats)
Any ideas .... I've looked at sharing / protection ... cant find anything to fix it....
It cant be protection because the paste special formats works fine with a mouse or the new 2007 Alt key commands?
Just about ready to remove and re-install...
When I noticed that FileSearch was missing after I updated to Office 2007, I decided to recreate the class and save it as a file to import anytime I needed to use it. I tried to use as little code as possible, so if there is some property you would need to add then you may have to add it yourself, but this will at least give you most of the funcitonality of the original Class without having to update your existing code too much.
You have to just reference the class and then it can still be used in a with block or however you are accustomed. Here are the two class files that I have, the first I named FileSearch (go figure):
Dim pLookIn As String
Dim pSearchSubFolders As Boolean
Dim pFileName As String
Public FoundFiles As New Collection
Public Property Get LookIn() As String
LookIn = pLookIn
End Property
Public Property Let LookIn(value As String)
pLookIn = value
End Property
Public Property Get SearchSubFolders() As Boolean
LookIn = pSearchSubFolders...................................
I've just installed Windows 7 32bit and put my Office 2007 suite on. Everytime I open Excel I get an error message stating: Compile error in hidden module: modMenus
View 9 Replies View RelatedI have an Excel spreadsheet that I have developed into an over the top flight calculator/scheduling tool. I am using Excel because developing this prduct into a stand-alone program would be absolutely murder to get approved for use on my network.
Since Excel and Access has already been approved, I began coding this project there.
Now that my calculator functions are nearly complete, I am beginning to develop a database of airfields and other misc. flight data that I and others on my network can see and manipulate. To make my calculator funtion at 100% effectiveness, I will need to use VBA to open the Access DB and pull out specific data. I will also need it to open and display some Access pop-up forms that I have just developed. Does anyone know what code I would use for excel to display and retrieve Access' information?
I have downloaded Excel 2007 as a trial on to my computer (with Excel 2003 in another directory), when I load an excel file developed in Excel 2002 (containing macros) and try an open it with Excel 2007 the message "This workbook has lost its VBA, ActiveX controls and any other programmability-related features" - no problems in Excel 2003
My operating system is XP SP2
We have a number of Macros written for Excel 2003. We have now upgaded to Excel 2007 and the macros no longer function. The main problem seems to be connected to the removal of the Office Assistant from Office 2007:
Assistant.On = True
With Assistant.NewBalloon
. Heading = "Reports Menu"
.Text = "Select your reports"
.CheckBoxes(1).Text = "Activity Schedule"
.CheckBoxes(2).Text = "Customer Schedule"
.CheckBoxes(3).Text = "Monthly Schedule"
.CheckBoxes(4).Text = "A3 Print by Customer"
.Button = msoButtonSetOkCancel
.Show
If .CheckBoxes(1).Checked Then
Module1.ACTIVITY_SCHEDULE_PRINT
End If............................
The above code falls over at the first statement with Run-time error '-2147467259 (80004005)': Method 'On' of object 'Assistant' failed. Has support for this object been removed from Office 2007 completely or is there a workaround that I can use?
I have big Access file .mdb. I need to work with the file in Excel.
The Excel read the file and I tryed to save the file as .xlsx
I receive a message saying only 64k rows will be saved.
How can I translate the file to Excel 2007?
I am trying to make a timesheet in Excel 2007 with a formula.
I want it to read:
IN = 8:30 AM, OUT = 11:30 AM, IN = 12:30 PM, OUT = 4:30 PM
The total hours will be 8 because there is an hour for lunch.
And if I work a few hours one day and leave before lunch, I want the calculation to be right. I found a formula but it wouldn't add the lunch hour and I added a +1 in the formula but it makes the calculations wrong for when I work for only 2 or 3.
how to add rows which was so simple in earlier Excel versions, but now is bafflegab.
Even after several efforts to comply with what follows when at INSERT, all I got was to move cell I'm in one to the right with all other cells in the row following suite.
OF COURSE I had specified "entire row".
Excel 2003 used to have a feature where the user can select and set the print area. I do not see this feature in Excel 2007. So, how dow I set the print area in Excel 2007?
View 2 Replies View RelatedI use Excel 2007 which is creating a whole load of tmp files of the spreadsheet that I work on.
Is there a way tostop Excel from creating and saving the tmp files?
Originally Posted by Question
Create a well labelled pie chart on a separate worksheet to show the profit made by each of the Liverpool departments to the overall profit for 2006. On the labels show the percentage contributed by each department.
I want to create a pie chart in Excel 2007. The data is not next to each other in the columns. How do I create a chart so that it includes the legends as the various departments and the data shown as the figures given under 2006?
I have some schedules set up with multiple formulas and macros (originally setup in 2003) however when attempting to make this a 2007 file when I go to copy a sheet to create another schedule I get the message “A formula or sheet you want to move or copy contains the name “xx”, which already exists on the destination worksheet. Do you want to use this version of the name? To use the name as defined in the destination sheet, click yes. To rename the range referred to in the formula or worksheet, click no, and enter a new name in the Name Conflict dialog box.”
View 2 Replies View RelatedI occasionally see array and/or sumproduct formulas that incorporate symbols that I don't really understand in an array context.
These symbols include:
* (asterix)
| (vertbar)
. (period)
; (semicolon)
Also: are there other powerful symbols that have meaning in an array or sumproduct context?
I'm looking to disable the horizontal and vertical scrolling in 1 worksheet
Am i able to do this?
I would like to send a .xls file created in Excel 2007 to a user who will work with this file on a PC that runs Excel 2003. Will they be able to open and use a file created in a newer version of Excel?
View 5 Replies View RelatedI do a lot of validation of Workbooks (Excel 2000). To physically show that only specific cells are unlocked I use a combination of Defined Names and Conditional formatting which uses the old Excel 4 macro command "GET.CELL" as follows
View 4 Replies View Related