Search results for query: *

Hey Folks. SETUP: I know how to: (a) use image mouseover events within a worksheet module; and (b) How to invoke/use an application-level eventhandler to track application-wide worksheet & workbook events.. QUESTION: Is there a way to create an application-level or workbook-level...

Howdy folks. I have exhausted all my efforts on this one. First off, I know there are posts for "cascading comboboxes", but they are not this situation. I currently have a combobox that employs the .dropdown method upon clicking on the combobox (no big deal). Upon selection from the dropdown...

Howdy Folks. I've got an EXCEL XP / VBA app which generates PDF's to specific output files automically (no user intervention with an Adobe dialog). It's quite simple, using the .printout method and the PDFWriter driver as follows: ActiveWindow.SelectedSheets.PrintOut PrintToFile:=True, _...

Hello all! I use the code below to "export" selected sheets from a workbook as excel, csv, txt, etc. (on the saveas fileformat differs). Just recently, I've begun to have issues with the activewindow focus. I believe it's speed-related within a Novell server environment. The problem is...

Hello all. I've just added some code to check for an environment supported by my Excel VBA app. At this time, is only Excel XP (version 10). If the version is NOT supported (i.e. Excel 2K), the workbook is closed without saving. Problem is, the VBA Project is still hanging around!! I've...

Hello all. I've got an Excel VBA app that's worked fine for years but now IN A NOVELL SHOP, I'm getting a 1004 method failed error with the Application.ActivePrinter = default_printer (default_printer being the string holding the default). The app uses the Application.ActivePrinter method to...

I've exhausted myself trying to fix this one. HELP!! I have lost all of the drop-downs for all cells with data validation ON ONE WORKSHEET. All other worksheets are fine. The validation is there (Data>>Validation) and it's enforced, but the dropdowns are gone. Even if I add a new validation...

Hello everyone. I've been using checkboxes, option buttons, etc. in EXCEL for some time but have never figured out how to re-size the button or box ITSELF. Some of my sheets have a small "zoom" percentage (i.e. 65%) and the buttons / boxes are much too small. Is there a way to do it? Thanks...

Hello everyone. I can't seem to gather enough pieces of code thru help and the web to do the following. I have a defined constant in an EXCEL VBA and I want to change the value in the VBA code itself. I know it involves using the VBProject object, but I can't find an example to go directly to...

Hi Tek-Tippers. I could really use your help here. I have tried several different things trying to speed up the code below, but it still takes an unusually long time. I've got Application.Events & .Screenupdating set to false. I also have Application.Calculation set to manual. Below is the...