Search results for query: *

Search the registry. If the CLSID appears in "HKEY_LOCAL_MACHINE/Software/Microsoft/Internet Explorer/ActiveX Compatibility" then check the Compatibility flag. With some ActiveX's if the flag is other than 0 the control will be blocked (not trustworthy). If IE gets (automatically) updated, the...

If Msgbox("This action cannot be undone, and will transfer your data and blank your sheet.",vbOKCancel+VBCritical,"Data Transfer") = VBCancel then Exit Sub

This is exasperating. I have used regwrite to enable MSCOMM32 on other machines including Vista and Windows 7. A new laptop showed up and regwrite doesn't change the compatibility flag value. Using Shell and calling a .cmd file that calls a .reg file doesn't work either. Running either the...

Your correct, it's the wrong approach. I suggest you dump the Spinbutton and insert a regular Commandbutton from the Controls Toolbar. In design view (click on the draftsman triangle on the toolbar) right click on the commandbutton and select properties. In the properties window change the...

I had a similar problem and found a solution thanks to help from the folks on the VBA forum. http://www.tek-tips.com/faqs.cfm?fid=7241 is the link to the FAQ regarding ActiveX and Vista/IE. Greg

In Excel if you set DisplayAlerts = False, it is a permanent setting to the Help options of the office assistant. That is, it doesn't get set to "True" when the procedure ends (like ScreenUpdating does). I'm not a Word guy but it looks to be the same in Word with the added fact that there are...

Genomon says look here... http://support.microsoft.com/kb/178456 Or you can use the shell command to call up the system volume application... Shell "c:\Winnt\System32\sndvol32.exe", vbNormalFocus Either way you appear to be stuck with a dialog box rather than simply entering a parameter.

Hi Skip, Yea I started to do that but the program is set up to take position and speed settings from the slide controls and output in real time to the servos (using the scroll event) so the user can see what each movement is doing. It is real convenient to switch back and forth between...

The Auto_Open() sub runs fine and adds a menu to the Excel Commandbar. Selecting commands brings up different Userforms. The small userforms come up OK. Selecting the command that brings up the large userform (12 page multiform and 450 controls) crashes Excel. If I start the VBE first, there...

An Auto_Open() sub will run whenever the workbook is opened. The code must be in a regular code module. Since you have three possible options (paid none, paid some, paid in full) you probably need a userform (as opposed to a MsgBox / InputBox combination). It appears that the userform needs a...

It's important to keep learning. It keeps a brain active and flexible... I remember reading an article once in In-Fisherman. It was about electricity and fishing and had to do with putting a small charge on a steel downrigger line. It was one of the great fishing articles that I ever read...

In your first post you say "...then separate a worksheet into a new workbook". Is the Button Code on the sheet that gets moved to a new workbook? Maybe an external link is being created. At the end of your code (after the worksheet gets moved to the other workbook) try adding code that resets...

I am not sure about 2008 but... Look in <Assist menu - Optons - System tab, Single Drawing compatibility mode. Deselect the box.

Two things you can take a look at... 1. When you say "Hit a Shortcut" do you mean a desktop shortcut that might start another session of Word? (A session that doesn't have the template open and consequently doesn't have your menuitem?) 2. Is the offending addin (that starts from the shortcut)...

Hello, Comboboxes, dropdowns, etc. all hold values as strings. Use the VAL function to change the combobox value to a number. Sheets("data").Range("J1").Value = Val(case1) If you allow a user to input something then you should add a couple of lines of code that check to make sure that...

Your msgbox syntax is wrong. Replace the word Prompt with your message. As written, your messagebox is looking for a variable named Prompt. Use parenthesis when you need a return from the message box (which button did the user click)... MsgBox "The file will not be saved", vbOkOnly +...

More searching turned up this site. The 2nd posting of his code works. He gets the star. http://www.pcreview.co.uk/forums/thread-956813.php

When there is no workbook open the icon is not there. So it's the "Workbook Icon" I want to change.

Thanks for the try genomon but that code changes the Application icon at the left end of the title bar (I have that one taken care of). The last bit of customization I want to perform is to add my own icon to my custom menubar. The same Excel icon that is at the left end of the Worksheet Menu...