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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BruceMutton

    Multiple Files with VBA Macros Using same Shortcut Key

    I have multiple simultaneously open files that have similar VBA code, and use identical shortcut keys, Ctrl+shift+V in this case. The problem is that excel97 & excel2000 does not seem to recognise more than one shortcut key allocation, and my attempt below to get each file to stamp its own...
  2. BruceMutton

    Return the Object that belongs to a CodePage

    The opposite of this is easy to do, using Object.CodePage however CodePage.Parent only steps up the VBA object hierachy towards the VBE. The only way I can think of is by brute force... For Each <worksheet & object> In ThisWorkbook If <worksheet & object>.CodePage Is <codepage I'm looking...
  3. BruceMutton

    Finding æConstantÆ name if number &amp; Enumerated data type known

    Thanks dsi, that is how I started out, and I thought, there has to be a better way...
  4. BruceMutton

    Finding æConstantÆ name if number &amp; Enumerated data type known

    ...to continue my thoughts. The data types, such as xlCVError or xlPaperSize are like collections in concept I think, however I do not seem to be able to use collection syntax, such as xlPaperSize.Count or For Each lngConst In xlPaperSize...... To get really specific, the problem I am trying to...
  5. BruceMutton

    Finding æConstantÆ name if number &amp; Enumerated data type known

    Is there a concise way of doing this while executing VBA? In VB Editor I can use the object browser, but this does not help while the code is executing. For example I might have a number returned from a function that I suspect matches one of the xlCVError enumerated data type constants...
  6. BruceMutton

    Toolbar Management

    I have used variations of yakpols and Malas solution in Excel95, 97 and 2000 An interesting dilema is that the Application.CommandBars(&quot;MyMenu&quot;).Delete code behaves differently in 97 and 2000. I forget which is which, but one deletes the commandbar from the application collection...
  7. BruceMutton

    Wrap Text in Excel2000

    DanielH, Like Mala I wondered why it only worked sometimes... Now add the the &quot;merged&quot; property to multiple cells on a single row. Autofit once again does not work, but I'd really like it to. (I use Excel 97 & 2000) Has anyone found a way?
  8. BruceMutton

    Linear Interpolation, one variable, Excel

    Further to threads thread770-14670 and Thread770-13682 A rather verbose, but comprehensive user defined function follows, and can be pasted directly from here, into your spreadsheet. If anyone has bothered to do one for two variables, I would appreciate a copy. Thanks Bruce Mutton Option...
  9. BruceMutton

    how can i hide a macro

    Macros In the Visual Basic Editor, programmers can protect macros so that they can't be viewed or changed by users. Programmers can protect macros by using the Protection tab of the Project Properties dialog box in the Visual Basic Editor (Tools menu, Project Properties command). For more...
  10. BruceMutton

    Excel File Size &amp; Memory Limitations? How best to proceed?

    Thank you all. The MS KB articles referenced, and a few others, do not, I think, exactly apply to my problem, but are fairly close and point out a few pitfalls to be avoided. More feedback welcome. Ctruax's approach seems promising. I often have files which by deduction have a faulty...
  11. BruceMutton

    Excel File Size &amp; Memory Limitations? How best to proceed?

    Am developing a workbook to perform some engineering analysis and design calculations. It is linked to a multisheet set of datatables. Contains about 16 sheets, and these have about 28 embedded charts. A number of the sheets contain vba code pages to iterate to a solution on each calculate...
  12. BruceMutton

    Excel .EventsEnabled Worksheet Function

    Good idea, but no difference, with this line at end, begining, or beginning and end of function. (The function is only called by excel in response to a 'calculation' in any case, so it is probably just causing a second calculate each time) On every calculate, it just flashes up TRUE for an...
  13. BruceMutton

    Excel .EventsEnabled Worksheet Function

    Thankyou yakpol. I tested the code with Excel 97 as you described, which is how I knew it was not working on my machine. I used the worksheet with Excel 2000 last night, and noticed that it always returned FALSE (regardless of the state of .EnableEvents) I did not think to test it from the...
  14. BruceMutton

    Excel .EnableEvents Worksheet Function

    thread766-11466 contains the full text of my question, however it commences as follows... Hi all I have written a simple user defined function to make it apparent on the worksheet when events are no longer being triggered. (I have an iterative solver type routine that is triggered by the...
  15. BruceMutton

    Excel .EventsEnabled Worksheet Function

    Hi all I have written a simple user defined function to make it apparent on the worksheet when events are no longer being triggered. (I have an iterative solver type routine that is triggered by the calculate event, rather than using an on sheet button) In a worksheet cell, I would enter...

Part and Inventory Search

Back
Top