General

Unhide macro worksheet
I have created a macro in my personal.xls worksheet. I want to delete the macro but am getting a message that I need to unhide the worksheet. I cannot locate the worksheet where the macro is stored and cannot find the command to unhide it. Help!!! Thank you very much, -- JoeF ... 4 Mar 2010 16:58

Custom format Numbers
hello, I am using the following custom format for thousands, but I also need to show a dash ie "-" if the value is a zero, thanks for your help!! #,###, ... 4 Mar 2010 14:41

in 2003 i have 0 text file conrt to 2007 number
i have a file in 2003 excel, one field is in text delimited format. How do i convert this without lossing the '0' at the beginning of the number. ... 4 Mar 2010 14:41

Can't open an excel file (have 2007, Vista) without saving fir
Thanks Tinytall, that worked for me! "Tinytall" wrote: Here is what fixed it for me. This is different than any of the above steps. I got this direct from Microsoft Tech Support. Edit .xls file type 1. Click on Start > Control Panel. 2. Double click on Folder Options and select File Types tab. ... 4 Mar 2010 13:32

Excel 2007 prompt to open file as read only
I would like an Excel 2007 file to prompt the user to open a file as read only. How do I do this? Thank you! ... 4 Mar 2010 13:32

Too Many Different Cell Format
I got error message " Too Many Different Cell Format". Anyone know what caused it? Thank you. ... 4 Mar 2010 13:32

Schedueled Auto Send .xls File to Receipients
I have an MS2007...I have a progress tracking excel spreadsheet that I must send to certain associates on a biweekly basis. What functionality exists or coding is reqiuried for my document to be automatically sent to selected receipients on a scheduled basis until the project is complete? ... 4 Mar 2010 13:32

copy and paste if
In column "A" I have my subtotals I need to find subtotal "Jim" in column "A" of worksheet 1 xlToRight get subtotal amount copy and paste into a cell in worksheet 2 -- Randy ... 4 Mar 2010 13:32

Excel 2007 SP2 Bug?
The following procedure causes Excel to hang. We have tested on XP and Windows 7 (x32 and x64) machines. It does it with SP1 or SP2: 1. Open Excel and select Format\Protect Sheet 2. Select Locked Cells, Select Unlocked Cells, Insert Hyperlinks 3 While protected, right click on the icon in the upper left corn... 5 Mar 2010 15:06

Can Excel sequentially number each new document?
We use an Excel Template to generate client proposals and would like that each proposal carries a unique sequential number. Is there a function in Excel that generates unique and sequential numbers every time you open the Template or when you safe it...? ... 4 Mar 2010 12:22