General

Automatic Userform Excel 2003
Can anyone advise if it is possible to create a form using Data > Form and then save that form so that it can be customised ie colours, logo etc in VBA Any help would be appreciated Thanks BJthebear Scotland ... 16 Mar 2010 17:26

Can you insert a watermark on an Excel Document?
I was wondering if it was possible to enter a watermark on an Excel document like you can in Word. ... 16 Mar 2010 12:33

Why Does Word Document Open Different On XP and Vista?
I completed a document on Word 2007 on a XP computer. I then opened the document in Word 2007 on a Vista computer and some of the styling and spacing was different? Is there a way I can fix this? ... 16 Mar 2010 21:00

Excel UDF copy cell with formatting
Does someone have a UDF that can copy the value from another cell with formatting? ... 16 Mar 2010 10:16

Carriage return
I am using Excel 2003 I know when I want a new line in a cell I press (ALTand Enter). Is there any way to make the line space the same as the height of a row; when I am doing it the line after (ALT and Enter) is at least double space. Thanks in advance ... 16 Mar 2010 10:16

separate columns (three letter code)
Hi, does someone know how to separate text from one column into two columns? I have columns like [dog, KKL] [horse, PPN] Everytime, three capitals in the end (which is a code). Is it possible to separate that, and put it in another column? Thanks in advance. ... 16 Mar 2010 10:16

reduce excel file size
The total size of my excel file is now 23Mbs, can any one know how to reduce the file size for Excel 2003? ... 16 Mar 2010 06:52

date problem
Hi, i need to know what day and month is the below date. 161th day of 2008 i have many days like this. i need a formula or something. I need them in dd/mm/yyy format. Can this be done? Thanks! ... 16 Mar 2010 07:58

Custom Sort order issue
Hi. I have created a custom sort order by using a list in a hidden sheet in a workbook. This is then followed by two default sorts. I recorded a macro of this sort being performed on each of the sheets in the work book and then used the Visual Basic edittor to make it run each time the workbook is opened. T... 16 Mar 2010 09:08

How to set Excel 2010 as default for open excel files instead of 2
I recently installed Office 2010 Beta. When i click on an excel file it automatically opens in Excel 2007. How do i make Excel 2010 default when i open an excel file? ... 16 Mar 2010 02:27