| Thread | Last Post | Replies |
|
| how can I get into a cell that it"s protected with a password | 26 Feb 2007 01:36 GMT | 1 |
I need to open a protected work sheet that I have protected years ago and have forgotten the password that I have used. Can somebody please help me ASAP Thank you
|
| match vs find question | 25 Feb 2007 23:16 GMT | 4 |
right now i'm using find to search a row of values for an item, if it find it, i use the rngfound row to enter some data below. if it doesn't find it, it adds an item to the range. i could use application.match to return the position, too, so i'm just wondering
|
| Access to user-created menu | 25 Feb 2007 23:09 GMT | 9 |
Excel XP & Win XP I have a user created menu that I built with John Walkenbach's easy menu maker. The menu has about 30 items. Of course, the menu is available to any open workbook besides the also-open intended workbook.
|
| Fill cells with names from list | 25 Feb 2007 22:40 GMT | 5 |
XL2000 I have a workbook I want to use in multiple counties. I have a list of student names in a named range "Students" in ColAD ColA contains each students name followed by a list of classes followed by
|
| Grid Selection | 25 Feb 2007 22:32 GMT | 2 |
Is it possible to change the colour from black to cell colour, making the grid invisible? Thanks - Kirk
|
| Cell References | 25 Feb 2007 21:44 GMT | 1 |
Ok I am trying to create a cell that displays an IP address based on a starting address on the front page. The address that I start this off of is actually 4 cells (one for each octet) which I am combining together. It works fine, but my problem is that if I change one of the ...
|
| Help with vlookup with certain cell change | 25 Feb 2007 21:24 GMT | 4 |
I'm a newbie with Excel VBA so please beare with me. I'm developing a daily logging spreadsheet on all the employee's attendance. This spreadsheet comprises of 2 sheets;"incidents" and "name". First being the logging sheet and the later contains a list of employee's name.
|
| worksheet_change colour of a row on change of cell | 25 Feb 2007 20:52 GMT | 6 |
Hi - can anyone help please I've tried Subject: RE: More than 6 conditional Formats....VBA Coding Advise please 1/5/2006 7:08 PM PST By: JulieD In: microsoft.public.excel.newusers
|
| Outlook attachments | 25 Feb 2007 20:42 GMT | 2 |
Each Monday I run a VBA generated office inventory report in Excel. Each employee's inventory is output to a separate worksheet tabbed with his or her name. The VBA code includes a procedure that attaches each employee's report to an Outlook e-mail. I've been running this program ...
|
| Putting the name of a worksheet in a cell | 25 Feb 2007 18:54 GMT | 2 |
What code do i need ? Thanxxxxxxxxxxx Luc --------------------------------------------------------------------------------
|
| Can I start the text import wizard automatically? | 25 Feb 2007 18:47 GMT | 4 |
I have a file format which is actually CSV but has my own extension. I`ve manually registered it in the windows registry to be opened by MS Excel. If I open these files from Windows Explorer (not from Excel "Open file" dialog) I need to start Text import wizard manually to ...
|
| Macro to move a cell to centre screen | 25 Feb 2007 17:29 GMT | 2 |
I want to write a simple macro that will make a given cell (defined by the contents of two other cells - i.e. row number and column number) move to the centre of the screen (approximately). Is there a simple way in which I can do this please? I can't find a function
|
| How to reach Application Objects in Events? | 25 Feb 2007 17:27 GMT | 3 |
Need to perform Range("A:A").Find operation in ActiveSheet.Button1.OnClick event handler in module (not in a class!). Button - member of the sheet. But, Application members seems to be not visible for events until they specially declared (if I call event
|
| iterate through chart series collection | 25 Feb 2007 15:30 GMT | 8 |
sorry to be bugging the group so mych about charts but Im getting my butt kicked. The new problem is this: Building a column chart and needing to add the series x axis labels which are set in VBA with
|
| Pass a string to an address | 25 Feb 2007 14:18 GMT | 3 |
In this snip I need to pass a range.address of a range to a string, manipulate the strig and then pass it back to the range.address. the first two steps are fine but I get an error "assignment to constant not permited" when I try to pass the string back to the address.
|