I have an Excel model with several VBA macros that I have been maintaining in Excel 2003 for years with no issues. Range("Range 2").clearcontents ' Up to this point, Screenupdating=FALSE on ALL machines Sheets("Sheet 3"). Is there an Excel Options setting that could be different between our machines that could be causing this? That eliminates the need for the Screen Updating in 90 percent of the cases.
I recently updated to Office 2007, made some adjustments to the model, and it works fine on my machine (and fine on some of my coworkers' machines). Select ' At this point, Screenupdating=FALSE on some machines and TRUE on others Range("Range 3"). Every use of Select tries to trigger a screen update. Form1 has two subforms, one with with recordsource Query1a and the other recordsource Query1b. A user makes choices on Form2, then clicks off a process that creates Query2a and Query2b dataset, which needs to be shown back on Form1.
By getting each as a CButton in turn (using Get Dlg Item)(yuk! If so you could have them turned on for most of the macro. I installed it all right, entered the product key, and now whenever I try to open it, I can't do anything. One of the columns in the original worksheet contains the formula =Quarter Num(cell reference) Under Excel 97 this formula would display the quarter number for a date entered into the referenced cell. When I place the cursor over the cell a tan colored box pops up displaying #NAME?
) and the applying the appropriate Set Check() I can set... Are you switching worksheets, inserting/deleting worksheets, printing or turning protection on... I have a rule which whenever an email come into the Inbox, if the person is in my address box to move the email to another folder. And when I click on the cell a white box containing an exclmation point inside a diamond shape pops up to the left of the cell...
error the field exists and is either number or currency data type.
Discover this word and many others that you can use in combination with Application in the downloadable course on Excel macros. As you can read: starting in cell A1 a value of "99" will be entered in the selected cell then the cursor will move one cell down to enter "99", repeat the process until the row number of the selected cell is 3000 and come back to cell A1. So I need to understand what is causing the issue, as unfortunately I don't think any easy work-around will suffice here. Range("Range 2").clearcontents ' Up to this point, Screenupdating=FALSE on ALL machines Sheets("Sheet 3"). The model contains thousands of lines of code over several modules and userforms, and requires the opening and closing of other Excel workbooks."VBAActuary" Check Radio Button Over the years, I've never got this function to work - not that I need it very often (there are usually better ways). I've done this before but I'm missing something about how "Me" works.Given that the tab and group order flags for the radio buttons concerned are correctly set up, and their ID's are in the correct order, then why doesn't Check Radio Button( 1001, // first, 1003, // last 1002 // The one I want checked ) ; .... Return code is non-zero indicating no error, but no buttons are checked. Hi Geoff, Are the macros calling other macros that are also turning off screen refresh and calculation and turn them back on. Keyboard and mouse seem to not work with word Version: 2004 Operating System: Mac OS X 10.5 (Leopard) I just upgraded from a Powerbook G4 to a Mac Book Pro, and I've used my second key for this Office 2004 edition (Student and Teacher). I can't even close the program without Force Quitting (as I can't use the mouse and I can't do Command q). I reopen Form1, change the recordsouces of the subforms, but then the screen does not yet know that the subform recordsources are different,so I t...=Quarter Num(): How to make it work in Excel 2003 I recently switched from Excel 97 to Excel 2003 Today I tried to use Excel 2003 to enter data into a worksheet I originally created with Word 97.Screen Updating = False HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your Work Book before attempting to make changes.