| Thread | Last Post | Replies |
|
| Recover Password | 29 Jan 2007 21:30 GMT | 1 |
Is there an easy way to recover/remove passwords for sheet protection?
|
| A list of software in Excel to show as header | 29 Jan 2007 21:21 GMT | 1 |
I have a spreadsheet look as the following: Name Title Dept Software Annie Hall Clerk ACCT Adobe 7.0 Office 2003
|
| transfer data from word userform to excel | 29 Jan 2007 21:15 GMT | 1 |
Does anyone know the proper method to transfer data directly from a word userform to an excel spreadsheet. I have the code below but am having no success...any feedback to point
|
| Read values from an Excel Table? | 29 Jan 2007 21:03 GMT | 3 |
I currently have a module that I created that reads a text file, parses it, saves it as a temporary workbook, processes it and then saves a final version. Works great. However, there are four codes that I need to look for in my processing.
|
| Looping with incremental variable/object names | 29 Jan 2007 20:14 GMT | 3 |
right now I have code similar to below: Variable1 = Form1.TextboxWidth1 * Form1.TextboxLength1 Variable2 = Form1.TextboxWidth2 * Form1.TextboxLength2 Variable3 = Form1.TextboxWidth3 * Form1.TextboxLength3
|
| Emailing Help | 29 Jan 2007 20:08 GMT | 1 |
Hello, I was wondering if anyone could help me. I am trying to get a code to copy a worksheet (command button on one sheet [named home], the sheet I'm trying to copy is hidden[named hidden]), paste special to a new worksheet with
|
| Emailing a worksheet | 29 Jan 2007 20:08 GMT | 1 |
Hello, I was wondering if anyone could help me. I am trying to get a code to copy a worksheet (command button on one sheet [named home], the sheet I'm trying to copy is hidden[named hidden]), paste special to a new worksheet with
|
| Wrap text doesn't work when sheet is protected | 29 Jan 2007 19:58 GMT | 2 |
I have been working on a employee review form that has unlocked merged cells. I have the following event code that fires when there is no sheet protection. However, as soon as I protect the sheet, the code doesn't fire. If I unprotect after the text has been entered, then it ...
|
| page break location in VBA | 29 Jan 2007 19:47 GMT | 1 |
How do I find the row number of where a horizontal page break is located for a given page number on a worksheet.
|
| ive been stuck for 2 days | 29 Jan 2007 19:08 GMT | 9 |
i have a single page worksheet with various information that automaticly changes and sorts based on another worksheet. whith that said here is my issue i need a script that checks wether there is information in colum (A).
|
| Problem programming .SeriesCollection().XValues and .Values | 29 Jan 2007 19:01 GMT | 7 |
Hi everyone. I am having a difficult time programmatically assigning a named range using the method SeriesCollection().XValue and SeriesCollection().Value. I keep getting the following error message, "Run time error '1004' Unable to set the Values property of the Series class. I ...
|
| VBA code to open and copy a file | 29 Jan 2007 18:38 GMT | 3 |
Is there a way to take the date entered by the user in cell C6 and write code to: 1) go find the file name that contains that date 2) open that file
|
| Userform: Display Scrolling View of Columns A:C | 29 Jan 2007 18:37 GMT | 1 |
Is it possible to have a Userform display ONLY Columns A:C, with a scroll bar to view values ? (Like a small window to another sheet)
|
| Generate Random Groupings from List | 29 Jan 2007 18:21 GMT | 10 |
This may be hard to do and a deck of cards may be my only answer In Column A I have a list of names - potentially up to 32 (never any more) What I need to be able to do is go thru that list and generate 4 even groups, so for example if there were 20 names in the list it would ...
|
| Opening excel | 29 Jan 2007 18:04 GMT | 4 |
does excel all ways want to open on sheet (1) is there a way to change it. Know I cna copy all data to another sheet. That means I have a lot of references to change also. This is reason to change opening page. Thanks
|