Search results for query: *

Gerry, I thought the messageboxes might be better for a newbie (which I gather Grove22 might be) than styles and keyboard shortcuts. The messages can be easier than trying to remember and/or annotate the shortcuts for the various styles. My only thought was to prime Grove to learn a little...

Grove22, How about a semi-automated procedure? It would seem this might be the easiest to write, and it would eliminate all of the programatic "guesswork". For instance: 1) Open document manually, start code 2) Code displays Messagebox1 with directions such as "Place cursor on the first...

hjgoldstein, Actually, a combination of both of Skip's suggestions might be the way to go: use the first for normal data entry, locking the cell as soon as the user moves out of it, and using the second to alert the user (via a message box) that the non-zero (or non-blank) value in the cell...

Gerry, At least this keeps us off the streets. Can you imagine the Colonels of panic that might erupt if this stuff got into the General public? It would almost certainly cause a Major problem that could only be resolved by the application of Corporal punishment ... in Private, of course...

Skip, Much as I support family interaction, this goes too far: Get your Auntie out of the pot or I'll be obligated to make a solo effort to contact the United Network Command for Law Enforcement! ---------------------------------------------------------------------------------- [ponder]"How...

Skip, I'm sorry, truly sorry, that your umbrage causes your resemblement to grow into a harpsicordian-like tic; a case of Stamitzian-Tourette's was not intended, nor was there intent to perpetuate numerological legerdemain. I throw myself on your merci...

Gerry, "Corrupted" ... hmmmmm. All of this did start happening at about the same time as the Made-Off scandal. Could it be ...? Nah. Just a coincidence.[grin] You're right, it likely is due to some property of the files being warped when the background program (ie, Office) developed a...

Loomah, I'm willing to share, but it falls into one of those "Twilight Zone" categories. I opened every single document that was in any way macro-driven, renamed them by adding a "1" to the end (ie, swap.doc became swap1.doc), and then copied them onto removal media. At that point I deleted...

Solution found!! ---------------------------------------------------------------------------------- [ponder]"How many surrealists does it take to screw in a lightbulb?" "Two -- one to hold the giraffe, the other to put the clocks in the bathtub." [lol]

The IT shop here at my day job had to rebuild my entire system profile last week (Windows 2003) due to a power supply problem, and I've lost some critical functionality under Office 2003. My problem is that I can't set Forms protection on any of my Word documents. This is something that I have...

2ks, One of the things that can cause this is the "Locale (location)" setting under Format-Cells-Number. If this is set to "Enlish (United Kingdom)" vs "Enlish (United States)" you WILL get the UK date format, which is MM/DD/YY vs the DD/MM/YY format we're used to here in the United States...

Gerry, Thanks for the feedback! If my problem had anything to do with the spell and grammar checks it won't show up again; these were moved to where they should have been to start with. This is code that I wrote a number of years ago when I was first learning VBA, so it is definitely not as...

...still couldn't find anything wrong. I ran it once more thinking that a screen shot of the error message might help, but I couldn't get one - the @*#! thing ran perfectly! On retrying it continued to run perfectly a dozen times, even though not even a single character had been changed. This...

PH, This didn't work either. The same "4198" error every time on that "Close" line. As noted in my first post, the most frustrating thing is that this same code works perfectly in other documents; it even works in another spot earlier in this document! There has to be some simple, little...

PH, Same result, with or without the comma. The only difference with the False inserted was the appearance of a message informing me that the document was being printed. It is still failing with the same error when it comes to the "Close" line. Any different thoughts or suggestions, anyone...

PH, Nope, with or without that False appended, it still fails with the same error on that last line. Thanks for trying. Any other ideas? I'm getting terribly frustrated by this, and by the feeling that the answer is going to be incredibly simple. [hairpull3]...

Hi! Can anyone shed some light on this? I am getting the following error: Run-time error '4198' Command Failed This is showing up at the bottom of a macro that opens a Word document, allows changes to be made, prints and deletes that document and then opens a form-field document which is...

I'm not sure what anyone else has, but the following will disable the "X" (Close) in the upper corner of Message Boxes: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End Sub I hope this helps. [glasses]...

Skip, That works perfectly. I knew it had to be something simple that was being overlooked. Thanks! Have a purple-pointy on me! * [thumbsup] ---------------------------------------------------------------------------------- [ponder]"Did you hear about the guy who refused to pay his...

...is in accord with the syntax in the Help file. Here is the code: Sub DoSegs() Application.Goto reference:=Range("j5") ActiveWorkbook.Unprotect (****) [highlight #FF99FF]Worksheets("name").Range("j5:j14").Locked = False[/highlight] ActiveWorkbook.Protect (****) ... code continues The...