Search results for query: *

Hi Fane Duru I have used modoless form and this is the code that i used to keep focus: Private Sub EvtHandler_Click(ByVal CommandBarControl As Object, Handled As Boolean, CancelDefault As Boolean) Dim ipos1%, ipos2%, ipos3% On Error Resume Next With Application .WindowState =...

Hi Fane Duru Thank's for the feeback. Wich version of windows and wich version of Office are you using ? Philippe p.s. I'm taking time right now to answer the other thread you answered me.

Hi Fane Duru "I mean only "Zipper un Fichier(WinZip) destiné au forum XLD" has to be shown. Isn't it? " Yes, this one work's(menu in excel) but unfortunately not the one in VBE. Philippe

Hi Tony Wow! Thank's for your time, and trying to help me. I wish there was some way, but.... Thank,s Philippe

Hi Tony Thank's for your answer. It was a good idea to verify that. Unfortunely, it was already enable. So no change in my problem. Thank's again Philippe

Hi Fane Guru Sorry for the lateness of my reply. (vacation) I have done what you gave me for advise. But the Tooltip text wont pup up. This is my menu code: Dim MyBarXLD As CommandBar Dim MyMenubarXL As CommandBar Dim Menu As CommandBarControl Dim CmdItemA As CommandBarControl Dim CmdItem2A...

Hi I have created a xla file. The main purpuse of that file, is to be able to copy the code lines of the selected VBProject on to the clipboard. In that file, i have created 2 userforms. The goal of the first one when called upon, is to present in a TreeView control, all the Procedure that...

Hi I have created a New Menu in VBE. I know in VBE, that to be able to Run the macro associated with this menu (OnAction), you need to create class module that dectect the events Click of that menu to run the Action. But, not being qualified enought (yet), i think you have to do the same king...

Hi GlennUK,TomThumbKP,3gm, ETID Thank's for all of your answers. I will look at all of your suggestions. Thank's again Philippe

Hi Sorry, for Winzip. And about the 7z, how does it compare to winzip ? Thank's Philippe p.s. lol

Hi Thank's for your help. But i realy need it for zip. Thank's again Philippe

Hi I would like to know if there is a open source code in VBA for creating a zip file. Thank's Philippe

I I found this site http://www.cpearson.com/excel/vbe.htm to help me a bit, but I have major stability problem. Thank's

Hi With an XLA file that load when Excel open, there is a new button in the vbe standard bar menu that appears. With the click of that button it pops up a userform that contain a TextBox that shows all the code that is present in the vbe XLA file. The problem that I have is that it always...