thank you all for your help but cant find any security issue or the trick with properties dont make any change.
i am thinking a way around to trick it and working it if i run a bat file from userform and that bat file have the order to open might work
its not perfect its quite unconvinient but might solve my problem for now. i am searching it right now
sorry for delay of answer but hard weekend. i cant see where this article helps me. i downoad the example but it is not about my matter or i cant see it. i will give another try tomorrow at office if i found time
i had tried that code also but failed
Runtime error '-2147024894 (80070002)':
method 'run' of object 'iwshshell3' failed
i use that code to open a help file from same folder that my workbook is (is in removable disk)
the strange thing is that when i call it from command button then opens many help windows instances
i guess for the each topic of help file
i tried many others help files cause that one it was made from me so i thought it was a problem from chm editor
but the same matter.
any thought why is happening this?
yes i know that i have found a way but need to be written in each mouse move. too much
i know my english are poor and might not be well understood. the test file that i sent have no code to activate for eace event. that why you might didn't see the bug. i resend the excel doing some changes .
your try royuk gives me an idea to add a feuture in my project ty
that was the original as i found in a site but i have changed in my needs of course
i have create a menu bar for my project and used mouse move event to run commands hoovering over textboxes
the bug of all this is when i want to run first command for example file-> open is ok but for next selection "save" cause i am passing over the "open" run again that "open"option so i have to go around that frame. i am thinking to put in my code a delay in mouse move sub and after that to click so to activate sub . but in search to internet i found a code to do for one case but i have plenty of options and cant write that code to each case. any suggestion?
even now i cant understand your code but i used only the first part with a small adjustment and worked
so i leave it as it is and in meanwhile see some bugs then i will return for the matter
thank you once again
i have two textboxes .the second textbox change its value based on textbox1 and vlookup in a range of sheet1
the matter is that the lookup range is in a column and value in b column so have to use a reverse vlookup formula but cant make proper syntax
i tried choose formula na some formulas with index and match
to solve my problem i made a column out of range in 68th and make to bring tha value of a column and did vlookup to search in 68 column
a lot of search before ask your help
seems something easy but as i said its syntax matter
Sorry for delay of reply. i changed my whole code to have better result and now tried and put your code roy to my project and seems that works
once again you did the work for me and appreciate it
i have made a great excel with many userfiorms and cover major of my needs.
i have stuck in a bug that bothers me and i think seems easy but i dont know why cant fix it
i have textboxes that i write dates. for example 11 march 2021 in a format 11-3-21
i update my workbook and then textbox changed to 3-11-21Code
i know somehow have to say value is date and format but as i have tried always some result
in my thought is to be a textbox with a " / / "
i have found a way to do this also but not work it a lot
yes it does the work not perfect as i was thinking but its ok and already i am using it
my idea was textboxes to be checked before the values being input in cell but your suggestion was one of my thought and i had made some tests with code but your is perfect.
i would like to add a fuction to a userform quite useless but it might help me somehow
so i have 30 textboxes with numbers from 1 to 30 textbox1, textbox2, etg. but i can change them and after the values of cells that are linked. but i dont want to have same number for example 2 times the number 3 and that means another number is missing and that before to input that changed values in workbook so a code that loop through to textboxes and in exit would pop up msg saying duplicate value would make my work. i found some code in web but dont do this that i imagine. so after many hours i came for your help
Re: start macro when book is open
ok after some tests finally works fine
thanks a lot for your help
Re: start macro when book is open
OK THIS WORK JUST FINE
i guess i didn't write the option explicit
so what about running macros when book is opened?