Excel Macros Question.

[Lambo]

Hey peope of the techimo community.

Quick question for you VBA gurus. I just got done with a Visual Basic class, and I am wanting to utilize my new found skills.

I know some of you may be shocked by the mere simplicity of the question but, got to start somewhere.

Ok, I'll quit stalling.

When you create a Macro for an excel spreadsheet, i.e
An auto run sub routine.

How do you keep the Macro enabled when you e-mail it to somebody?

Thanks,

[Epidemic]

AFAIK The macro is enabled no matter the way you send it.

Of course there are some coputers which maintain that macro protection junk. That will have to be turned off or set to prompt the user to bring in the macro. AFAIK there is no way for you to override this from the macro or that would defeat the protection value.

Sooooo, in the case where they have their machine set to full protection and they are not allowed to turn down the protection level then you are probably up the creek.

If their protection is just causing the auto run to malfunction you can always default to having a button or event activate your macro. I usually use the button method.

[Lambo]

Hey,'' thanks for the reply

I'm just now getting my feet wet with this VBA stuff. I didn't realize these kind of utilites were out there.

Do you know of any good beginner books or websites?

Thanks again.

[ctaylor]

I know you are eager to start using VBA now that you finished your VB class.

Perhaps you should take a look at MS Access. Within MS Access you can start using forms, setting commands at run time and design time, pull reports and do all of this with command buttons, combo boxes, list boxes etc.

When you start always remember that VBA for MS Access is not the same as VBA for Excel, Word, Power Point etc. Start by investigating the docmd. method in MS Access help files.

Hope this gives you something to sink your teeth into even if you don't have a full copy of VB.

[Lambo]

I appreciate your input, I just got a book(Microsoft Access 2002 Visual Basic for Applications). It was cheap.

Kind of a bummer to find out that VBA is different with Access. Not so much that I hate using access, but having to learn the syntax.

Oh well, time to dive in.

Thanks again.

[Epidemic]

http://ozgrid.com/forum/forumdisplay.php?fid=6

excellent resource (i have not used it recently as I have not been programming alot but it rocks)

[DrDave1958]

Didn't get what MS offive app you are leaning toward, but here's an Excel-lent resource for Excel.....

www.MrExcel.com

-Dave-