Search results for query: *

Hello All, I am back with an idea for a solution. Propably you guys can help in its implementation. Is there any way not to let a worksheet/book open, if someone chooses to Disable the Macros? The idea is to have a macro in a worksheet and let any body work in that sheet, only if they choose...

Thank you all for all your help in this matter. Sincerely, Sushil S.

Hello Ronald, Thanks for the solution. It worked well. But now I have two concerns- Everytime you open the workbook, it prompts to enable or disbale the macros - my concern is, one trouble maker may chooose to disbale the macros and then the problem will remain as such. Any way to bypass thsi...

Hello, We have an excel'97/2000 worksheet that everyone needs to work in. We can not make it shared. Sometimes, one person opens it, works on it and leaves it open forever. Is there any way, we can force the worksheet to close automatically after a set interval of time? Thanks. Sushil S.

Ken, Your solution worked perfect for me. I will have a look at the other problem too (just in case, I find a better solution). Thanks. SainiS

Hello, I am working in excel'97. One of the pre-defined values goes into each individual cell from A1 to A50. e.g. out of a list of values like- red, yellow, green, blue- every cell has to contain one of these colours(values). What I want is- instead of manually typing the value in each cell...

Hello, I work on an Excel 2000 sheet and I have to update this sheet every 15-30 minutes, so I always leave this sheet open on my PC (Excel sheet is worked and saved on a local shared drive). We have a local networking. But no one else updates this sheet except me. Is there a way that the...

Pechenegs and Wolluf- You guys have been of great help. Though I have tried almost every option, still I am gonna try once more in a step-by-step mode. Thanks.

Thank you all for your responses. As mentioned earlier, it is an IBM NetVista with WinMe. I did try with a new Maxtor 40 GB hard disk and installed w2k professional on it. Everything ok, but then system would freeze after some time. I tried Win Xp prof. on the same disk - same prob. And...

Hello, I have an IBM NetVista 2284-48U, came preloaded with WinMe on AMD Duron. Trouble is- IBM has something in the BIOS, which won't let me use XP or W2K on the same pc. It gets installed but then pc freezes constantly. I have wasted numerous months experimening with that and now I am back...

Thanks Ken. It worked perfect. Can you please explain the function of -- in the formula? Thanks. ~S

Hello, I am using excel 2000 and have a range of cells from A1:E1, which needs to be compared with values in A2:E2 and then count the result. A1:E1 is- 21,24,18,19,25 A2:E2 is- 20,20,20,20,20 The formula I have is- =COUNTIF(A1:E1,">=A2:E2"), which returns 3. The above formula...