Posts by max_lux

    Re: Addin To Allow Mouse Wheel Scrolling In The VB6/VBA Editor

    Quote from Krishnakumar

    Here is another one

    Nice exe, works fine, though not an Excel addin (.xla) or (.vhp)

    Just to note: This exe adds a dll hook to web browser(s) so it can access the internet. I blocked it via my firewall, but things like this are highly disturbing, as a dll hook can be used for keylogging...

    Hi all, long time no see. I've been working foreign and exotic places.

    Here is the macro:

    Now the problem is, in one workbook this works fine if this is the second to ninth save, but in a different workbook (the one I am currently working on), it does not resume next and defaults to an error. Is there any way to see if exists a window with the ("book#") name 1 through 9, and if so, then select it?

    Thanks in advance![hr]*[/hr] Auto Merged Post;[dl]*[/dl]Hi,

    I figured out the answer. See below code:

    Thanks for browsing :)

    Re: Exit Cell Event

    Ok thanks guys.

    What I want is; if the value of the cell is zero upon exit, the adjacent option button will become value = false.

    I will see if I can get this going. I obviously need some caffeine...


    I am running the following code to check if a value = 0 is in specific cells. Because this code on all the cells runs each time any cell in the workbook is calculated, the screen flashes. I would like to stop this screen flashing by having the check done only when the specific cells are exited.

    Thanks, in advance!

    Would there be, possibly, any way to run spell checker on a specific textbox (only) which is in a worksheet? I could always get around this by exporting the text to word, running the spellchecker, and then importing the text back to excel, but I would prefer doing this without the export.

    Thanks! In advance!

    Re: Overwrite sheet name?


    The macro saves the the names "SHEET3" but the next time it runs

    I have noticed it does the same with macros I run to save files. It will work fine the first time but not the second. I haven't figured out why this is, yet. When I do I will post.

    Re: Move macro

    Here is another code for importing from a text file.

    Re: Format Phone number as it is being entered

    Nice job Dave, I've wondered about code that does such a thing.

    Here it is for with the leading country number ie for North America +1 (000) 867-5309

    Would have to be formatted for Europe differently

    Max Length (17)

    Now to add isNumeric code, and figure out how to allow the user to backspace and correct without having to select everything

    Re: Protect / Unprotect Worksheets

    Even if the xlUnlocked cells is done, it is undone when you close the workbook (one of Excels wonderful quirks).

    You must run that code in the Workbook_Open event, in the workbook object. Then that is done when the workbook is opened.

    Re: Event For Protection

    Quote from Will Riley

    One thing you can do is to make sheets you really don't want people to see VeryHidden and password protect the VB module

    Done and done. I was just wondering if there was any way to implement sheet protection if it was haxrd. I could add protect code for worksheet_change, worksheet_activate, which would not make it perfect, just a pain in the a** for anyone who should try to mess with sheets.

    I know there's a way to get into everything. I have tryed hack one of my own workbooks to find out how secure it is. So far I have been unable to access the VBA project, using downloaded VB hack software, but I'm sure there are those that could. If I can't do it, however, I'm not too worried about my users.

    ***Disclaimer: I only use hack software on my own work to ensure security. I would not think about using it to hack anyone else's work. That would be unethical and immoral.

    Would it be possible to write an event whereby if a sheet became unprotected for (00:00:01), that it would be automatically protected? This would severly limit a sheet haxrs ability to do anything, even if unprotecting a sheet, yet would allow code to be run which required sheet unprotection.