Recent content by behbeh

Thanks, cLFlaVA!! I tried it programmatically in my module(s) and it worked great. I do have to keep toggling the Protect off and on throughout my app (depending on what I'm doing) but it works great. Thanks! [thumbsup2]

Hello! Is there any way I can capture when a user tries to delete a specific worksheet and cancel the delete or display a message stating they cannot delete a specific worksheet? Thanks!

Hi Loomah (and ETID), I could not get it to work correctly; not saying it doesn't work, I just couldn't get it to work in my project. The xls app I'm working on is bursting at 4MB (lots of scope creep) and Excel is being totally whipped already with major functionality squished into the vba app...

Hello! Is there any way to detect if the user is in Edit Mode in Excel (double-click a cell and the cursor is flashing within it)? I need to either disable my custom CommandBar buttons or display a message when this happens. Currently, if the user is in Edit MOde and goes to click a button on...

Thanks for the link, Loomah!!! Happy Friday to you as well! Also, if a man says something and there are no women there to hear him, he is still wrong, unless he is a member of this forum! :-{}

Well,I've been playing around with this and found that Excel disables the VB/VBA CommandBar buttons (as well as a few other CommandBars)when the cursor is in the Formula Bar. Unfortunately, hiding the Formula Bar is not an option. :( The problem is that my custom commandbar macros do not run...

Does anyone know how to programmatically detect when Excel's Formula Bar has focus? I need to disable a custom CommandBar when the the cursor is in the Formula Bar. Thanks!

Hello! I am working on an Excel application with a form for user input. I found that when I am on the last control on the form (a cancel button) and hit the Up arrow on the keyboard, the VB Control Toolbox displays. How can I catch this and prevent the toolbox from displaying? Thank you in...

whoops...I meant 35,000 characters!

When all is said and done, the length of the string would be around 3,500 characters. I guess I'm not so concerned at this point about the memory being hosed (this would have to be tested), I just want to make sure there isn't a MAX limit to the length of a regex. If there is no limit to the...

I have one regex I would need to have a little over 1,800 words listed in the alternation part. This would be sucked out of a database table as a regex string and then used in the front-end of the app.

Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...

Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...

Hey thanks Tony! I didn't know about "Sent.Information(wdWithinTable)". I'll check it out. Thanks for your help! :) BehBeh

Hi Tony, Programatically, I need to open a document and extract information (in sentence order). I have to bust the free-form text into sentences and throw those into an array for text. I also have to grab the info in the table(s) and throw that info into an array for tables...don't ask...