VB macros in new Excel

  • Thread starter Thread starter Howard Brazee
  • Start date Start date
With your workbook open hit Alr +F11 to open the VBE
Click to expand...

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
 
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.
Click to expand...
 
You could gotten there using Developer Tab>Visual Basic as I posted earlier.
Click to expand...

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
 
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.
Click to expand...
Button>Excel Options>Popular>Show Developer Tab in Ribbon.
Click to expand...

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


Gord
 
Back
Top