dialog box

Does anyone know why the filenames for most of my macros are appearing in the macro dialog box (in Excel 2010) and, more importantly, how to get rid of them? Example: PERSONAL.XLSB!ClearFill Thanks! Doug

Hi All, Can anyone help me to complete my code (Excel VBA) to automatically process a File Download dialog from Internet Explorer. I want to click "Save" which will produce the "Save As" dialog. Then file name should access from A1 cell and should get save in C:\Temp\ and click "Save" again...

I want to group columns in excel with the main column to the left, not right (as is the default). According to other posts, this can be done through the Outline Dialog Box Launcher... but mine is greyed out Dialog Box Launchers seem to work just fine everywhere else they appear in the standard...

Hi all, Forgive me if this has already been answered, ive been looking for a while now and not found an answer that works for me. Im trying to use a command box that will open a file (allfiles is what im looking for) and import it from a network drive into a worksheet in the same excel file to...

I have an excel table with sales data for many presellers. I have to make and updating table for each of presellers. I want to make one file with data for all presellers and to create a shortcuts to preseller folders and when some preseller opens file from his location I want excel to aply...

This may sound odd, but I was looking for ways to create a macro that would open a a dialog box that would prompt the user for a file that would then store that filepath to a cell, allowing the user to click on the cell to open it again. The excell sheet would serve as a checklist for many...

Hi again, Does anyone know the code for a - I don't know what it's called - "dialog box" in excel? I need to have a user enter the name of a file, have the code add ".xls" to the end, and then use it to open that file and use it for the address of a vlookup. In a perfect world, I'd love it to...

I found a very helpful piece of code that generates a "sheets to print" check box menu so I can specify what sheets to print as shown in this example pic: http://spreadsheetpage.com/graphics/tips/prsheet.gif but for whatever reason, the very last active sheet is printed whether or not I click...

Hi, I've been using the following code for some time, but my workbook has expanded and I now have over 40 sheets which users need to be able to select from. My question is: how do I amend this code to show checkboxes for all the sheets in the dialog box? I've tried increasing the width, but...

Hello, I would like to create a box that pops-up and prompts the user with an error message: "Return value is invalid. Please click 'OK' to correct." when a conditionally formatted cell returns an out of tolerance deviation (computed from a three-set data entry). How can this be done? Thank...

Hi There, I have a button (browseMain) that brings up a File Browse Dialog box. When i have selected the file i need the file location into the textbox (browseBox) next to the button. Any ideas how this is done Thanks

Using Excel 2003, I have a nice bit of code/ macro that will display a menu (msg box) of worksheets to print as long your worksheets are visible (not hidden).....it will offer a checkbox to print. However, I would like to avoid offfering the choice to print one of the tabs e.g. "Menu" tab...

I am trying to create a stock trading template in Excel. The template/worksheet will be minimized/running in the background while other applications run in the foreground. When certain cells in the template/sheet populate certain values (based on formulas or by referencing other cells) - can...

I have this code which is kind of what I want. I am using it as a good explaination as to what I want to do as well as a starting point. I got it from "The Spreadsheet Page" It checks all the sheets in a workbook loads a dialog box and lists all the sheets with data in with a check box with an...

I am writing a VBA macro right now that opens and closes multiple workbooks and worksheets. Is there any command I can put into my macro that will automatically tell Excel it is OK to delete this worksheet and to not save the workbook I am trying to close? Basically, I have...