VB macros in new Excel
On Mon, 4 Jan 2010 12:07:01 -0800, trip_to_tokyo
wrote:
If you don't get the Options button (towards the top of the screen that I
mention in my earlier posting) it's because there are no macros, "attached"
to that Workbook: perhaps that's why you are not seeing anything in View
Macros.
You have to enable this Options button because if you don’t the Edit button
(further down the process that I talk about) will be greyed out.
Please hit Yes if my comments have helped.
I can't hit "yes", from here.
So my SumEvalString works partly, and the macro that defines what it
does is missing. I wonder why it works partly, how I lost the
macro, and what I must be careful about in the future to make sure I
don't lose it again.
Next I will need to figure out how to re-write that macro.
--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."
- James Madison
|