Hello all,
I am using the built in Save As dialog box to get the name for a text file I am going to write out.
However, I want to check to see if the filename already exists in the directory the user wants to save the file to. If the file already exists then I would like a message box to...
I know what I want to say in English but can't come up with the right code that will do what I want. Here's kind of what I want the code to do using my English/VBA sub-dialect. Sorry for the non-technicalness of the code:
On error goto handler
Handler:
if the worksheet is protected then...
So here's the deal:
I have 10-15 comboboxes on one sheet where you can select various items from them. The selections from the comboboxes are then placed in cells in other worksheets of the same workbook. There is an option to select nothing from the combobox (ie blank line). If the blank...
I did try something like that with:
Sub mnuHelp_Click()
Shell ("start " & app.Path "\help.hlp")
End Sub
That worked fine until I copied the files (the *.exe, and the help file) into another directory. It wouldn't open the help file.
I'm having trouble launching a help file (with the ever creative title of "help")I created from the menu I created for Help.
Private Sub mnuHelp_Click()
App.HelpFile = App.Path & "\help.hlp"
End Sub
Am I missing something here or does anyone have an idea why this...
I understand what the code does but don't know exactly where to put it. Where should I place it so I can call it whenever a new form is loaded? I'm eventually going to have to call each time after a resize as well, correct?
I would like all my MDI child forms to come up in the absolute center of my MDI parent form. It seemed logical to me to change the StartUpPosition property of the MDI child form to 1 - CenterOwner but I get an "Invalid Property Value" error with that. Any help would be greatly...
I've created a custom menu bar and would like to add the print option from the file menu to that bar. I've written the code to create the new menu bar but just need help with the code to assign the print option to the NewItem that i've created call "&Print". Thanks in advance.
OK. I'm almost there. I wrote a couple of lines that would diable all the right click short cut menus. This works except for the right click menu on the Menu bar. You can still right click up there and add the toolbars back. Here's what I added. I didn't add it to Auto_Open and Auto_Close...
I did have a little problem with the code. I kept getting errors with the lines of:
aRemove(iRemove)=1
and
If a Remove(iRemove) = 1 Then
Also, as DarkSun pointed out the other bars need to be reset so that everything returns to normal after the file is closed. I'll play around with it...
We've created a economic model that we want to make more presentable to a client. We plan on putting this model onto cd and would like it to look as professional as possible when they open it. So we would like it too look the least like an excel program as possible. Can you program a macro in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.