General

Can I protect all excel tabs in a file with one password entry
Paul B: Thank you. Your macro worked very, very well. Thank you again. "Paul B" wrote: Indiana, you can use a macro like this, Sub protect_sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect password:="123" Next ws End Sub -- Pau... 17 Dec 2009 09:17

Your formuala also seems much simpler than mine.
Hi Ron,Your formuala also seems much simpler than mine. I came up with the following formula before I saw your solution: =(REPLACE(REPLACE(SUBSTITUTE(SUBSTITUTE(A1," ",""),",",""),SEARCH("Gaz=",SUBSTITUTE(SUBSTITUTE(A1," ",""),",","")),4,""),SEARCH("m3",REPLACE(SUBSTITUTE(SUBSTITUTE(A1," ",""),",",""),SEARCH("Gaz="... 17 Dec 2009 09:17

How do I round up numbers when dividing?
What I am doing is in regards to money. I am dividing an amount between two people and sometimes the amount can't be divided equally so I want to be able to have the formula automatically adjust. So for instance: $5000.23 divided by 2 does not divide equally. So person A should get $2500.12 and person be sh... 16 Dec 2009 18:00

Excel 2007 reformatting cells
I am having the most difficult time. I have time values in the format hh:mm:ss:sss, where the last three values are milliseconds. The problem is that they are seperated from the seconds by a colon, which leaves me unable to use them to calculate the differences between two of these times. I need to find a way ... 16 Dec 2009 12:23

Display or hide control characters in Excel 2007
In Excel 2007, how can I display or hide control characters? I can't find that option. I want to be able to see control characters in my spreadsheets (i.e. carriage returns, etc.). Thanks ... 16 Dec 2009 11:16

Excel 2007 Shared Workbook
Running Vista Enterprise, Office 2007 Excel 2007 - sharing a workbook file saved to a network drive. File worked with no problems in 2003 on XP Users open file make changes and try to save - receives errors: either - File is Locked or "The document was saved successfully, but Excel cannot re-open it because ... 15 Dec 2009 15:37

How to save files in the formats of *.csv(MS-DOS) in Excel 2003
I want to save excel 2003 file as file type CSV (MS-DOS) so that it will enable me to import file to SAP. searched in Excel 2003 and can only save file as *.csv only; - I request if there is a functionality in MS Excel 2003 to be added in order to save file as CSV (MS-DOS) file type. ... 11 Dec 2009 09:08

date filter in a pivot table
I have a pivot table created from data that includes dates. I have formated the original data column of dates as dates and have the dates as the only entry in my column data. Sometimes when I create the pivot table from new data, I cannot filter the column data with date filters, it only allows me to filter t... 10 Dec 2009 16:48

Excel 2007 file locked by 'another user' on windows 2008 share
I'm sharing Excel and word 2007 files on a SBS2008 server. Alle computers are windows XP with Office 2007 installed. When the users open an excel document they sometimes get File is locked by 'another user'. Disabled & removed antivirus software on server & client but that didn't resolve the issue. When i mo... 7 Dec 2009 07:24

Offset VLOOKUP results
VLookup returns a value in the same row. However, for my purposes I need the value in a row ahead or a row behind. So for example if Vlookup formula returns a value in Cell b3, I actually want to know what it's in the next row i.e. Cell b4 or possibly Cell b2 Does anyone have any thoughts?? Thank you! ... 5 Dec 2009 17:23