Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sksaini

    How to close an excel sheet after a set amount of time?

    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...
  2. sksaini

    How to close an excel sheet after a set amount of time?

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

    How to close an excel sheet after a set amount of time?

    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...
  4. sksaini

    How to close an excel sheet after a set amount of time?

    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.
  5. sksaini

    Drop down box in excel

    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
  6. sksaini

    Drop down box in excel

    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...
  7. sksaini

    Refresh or Auto. update in Excel

    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...
  8. sksaini

    changing BIOS

    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.
  9. sksaini

    changing BIOS

    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...
  10. sksaini

    changing BIOS

    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...
  11. sksaini

    Hello, I am using excel 2000 and

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

    Hello, I am using excel 2000 and

    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...

Part and Inventory Search

Back
Top