Search results for query: *

Greeting, Excel 2003, Workbook with a form. The form has a ComboBox which is populated during the UserForm_Initialize. The Combobox 'Style' is set to 2 - DropDownList. The last line in the initialize is to DropDown the list in the combobox for the user to view when the form appears...

Thanks for even looking, I'm trying to write a code in VBA (Excel) to search for a file with a specific value in it's builtindocumentproperties "Title". With Filesearch, I can search using 'TextOrProperties', but I only want to find a file with a specific property (title). Hope someone can help.

I have created an Excel spread sheet with numerous sheets and numerous VBA forms and code. I keep the VBA Project locked from viewing with a password. I have been making slight improvements as you do, and my program is working fine. Recently, on the odd occasion, after I have closed my Excel...

I have created an Excel spreadsheet with VB locked from viewing. A friend has shown me a program called "Advanced VBA Password Recovery" which was able to change the password for the VB Project without even opening the file, thus allowing someone to open the file and then view my VB code with...

Hi, I have a code in my "Before_Close" Sub, which stops the user closing my Excel file using the X in the top right corner. To exit I have an exit button which sets range "A50" to TRUE,then saves and quits. This bypasses the "If CloseMode". My Workbook_Open sets "A50" to FALSE If...

I have a few Excel Spread sheets projects with their own Auto_Close modules. The modules make the toolbars visible and a few other things as well as 'ActiveWorkbook.Save' to ensure any changes are saved. Problem - If I have more than one project open, and close one, the Auto_Close for the other...

Using MS Office XPPro I have a excel WorkBook with numerous sheets, One sheet "Summary" displays a summary of information from the other sheets by way of formula's. 1. I wish to save the worksheet "Summary" as a new xls file with only the values and formats displayed, no links to the original...

I wish to display a message box or userform, which will display the value of certain cells from a workbook. eg. Sheet 1, Range a1 = "12th Dec 2003" I want the userform to display "12th Dec 2003" I know that this is probably a menial task for most of you but I would...

I am running Office XP Pro at home. I created an excel workbook with macros. some macros sort data within a range. My home computer runs all macros correctly with no errors. I take the same program to work (Office 2000) and get syntax error at the point of sorting the data in the range selected...