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...
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...
...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...
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...
I have used variations of yakpols and Malas solution in Excel95, 97 and 2000
An interesting dilema is that the
Application.CommandBars("MyMenu").Delete
code behaves differently in 97 and 2000. I forget which is which, but one deletes the commandbar from the application collection...
DanielH, Like Mala I wondered why it only worked sometimes...
Now add the the "merged" 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?
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...
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...
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...
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...
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...
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...
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...
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...
