Search results for query: *

I timed the calculation of 1 record on 12 sec. However each record has 12 colomns who are calculated and as I have a few thousand records to calculate I want to know where the calculation can be optimized.

Hallo, I would like to know how I can calculate the process time between records in milliseconds? thx

Hi Cathy68, Making customized toolbars is easy if you use the following link http://j-walk.com/ss/excel/tips/tip53.htm. Put all your macro's in a module in your sheet and built your menu's with the above technique. It's easy and quick. Getting the wright FaceID (for the icon) is made easy with...

Hi, I want to distribute an application (built in excel97) I made. And I would like to use an registration key or a method which allows the user to install the program once. Basically I want to have the control on who is using the software, so no wild copies are distributed. Any ideas? DODO1

Thanks Combo, you get a star from me. DODO1

Thank You Combo Just 1 thing, how do you reset the counter? DODO1

Hi, Does anybody know how I can make a Demo version of an excel application using visual basic? I was thinking of using a date or counting the number of times the programme is started. thank you DODO1

Thnakd Peter, Just what I wanted to know! There' a star for you. DODO1

Hi Peter, The link confirms that the menu editor did disappear in Excel 97. What I now wan't to know, is if Excel97 was a part of a)Windows95; b)Windows98 c)an upgrade of MSOffice which runs with both Windows95 and Windows98 Thanks, DODO1

Hi, Does anyone know from which version of excel and windows the menu editor was removed from excel? I think it was excel 97 / windows 95... Can someone confirm this? thank you DODO1

an other way of doing it is to use the hidden property of the cells (Format - Cells - Protection - check hidden). This only works if you protect your sheet (Tools - Protect - Protect sheet). You don't have to add a password if you don't want to. You won't see the formulas adn your sheet is...

Thank You Tony that was the missing piece! You get a star from me. DODO1

Thanks Tony, I am now getting the menu "Window" which is what I want but it is empty. I would like to have all the items of the "Window" menu specially the part where the open spreadsheets are shown exp: book1; book2 etc. thanks

Hi, I am creating customized menu's in excel97. Is it possible to insert the original excel "window" menu in the customized menubar, so I can see which workbooks are open. thanks

Hi, I have created an xla in excel97. It's running fine when excel is already open (with or without an open workbook). But when excel is not running and I click on the xla icon to start my xla program, excel crashes when it tries to run my xla file (not when it's loading the built-in xla's...

Hi, I'm trying to print grouped excel sheets into 1 pdf file. When I group/select sheet1 and sheet2 of the excel and look at the print preview it looks fine (= as 1 document) and 1 pdf is created. But sometimes I'm asked for several filenames to save to. For example sheet1 is saved to...

Hi, Maybe this link :http://www.meadinkent.co.uk/xlgraphoffset.htm can get you started without the need of VB. Disadvantage is that you will have to create the 120 graphs yourself... but after that the offset function will take care of the dynamic. DODO1

Hi, I'm trying to print grouped excel sheets into 1 pdf file. When I group/select sheet1 and sheet2 of the excel and look at the print preview it looks fine (= as 1 document) and 1 pdf is created. But sometimes I'm asked for several filenames to save to. For example sheet1 is saved to...

Skip, After your remark I looked again and found the real problem: there was no data to graph.... and yes I am ashamed ;-) DODO1

Hi, I made a dynamic graph in a normal xls file by using the offset function and some named ranges. I used http://www.meadinkent.co.uk/xlgraphoffset.htm as an example. In the graph I have to mention the name of the file where the graph is part of for excel to bilt the graph. This works fine for...