VB macros in new Excel

H

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
 
G

Gord Dibben

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


Gord
 
G

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.
 
H

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending a macro-enabled spreadsheet 2
Programming question 5
Copying a row to another spreadsheet 1
Lost horizontal scroll bar 0
Office Macros 6
Ignore error 3
Months between two dates 5
Names 5

Top