VB macros in new Excel

[Howard Brazee]

With your workbook open hit Alr +F11 to open the VBE

Everything's solved. I will copy the above line into my spreadsheet
so that I can find it next year.

By looking at the code, I was able to trace down my data errors.


Thanks everybody for your help.

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

 

[Gord Dibben]

You could gotten there using Developer Tab>Visual Basic as I posted earlier.


Gord

 

[Gord Dibben]

Happy to hear you deciphered Alr as Alt


Gord

Everything's solved. I will copy the above line into my spreadsheet
so that I can find it next year.

By looking at the code, I was able to trace down my data errors.


Thanks everybody for your help.

 

[Howard Brazee]

You could gotten there using Developer Tab>Visual Basic as I posted earlier.

Ahh, I found the setting to turn this tab on. Apparently its
default was unchecked, which is why I didn't see it when you mentioned
it.

I guess the assumption is that a developer will know about this.

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

 

[Gord Dibben]

But I did explain how to place the Developer Tab on the Ribbon when I
mentioned it in my very first post.

If Developer Tab is not shown on the ribbon you must place it there.

Button>Excel Options>Popular>Show Developer Tab in Ribbon.

If you read all of the content of a reply you will generally get what you
need faster.


Gord