visual basic

[Arthur Keith]

How does a macro created in visual basic , become part of spreadsheet in xls? And, what process is used to remove it ? I have this problem when opening 1 excel work book there is a macro that has attached it-self to the work book , I click enable or disable and same result IPF in module Excel.Exe ...Help arthurk@ehsmd.com

[antonye]

The Microsoft Office suit (Word/Excel etc) use VBA (Visual Basic for Add-ins) which is a macro-programming language rather than the full blown VB language.

To add/edit/remove the macros in Excel, you simply need to go to Tools -> Macro -> Visual Basic Editor or press ALT+F11.

If you're having problems with a spreadsheet not opening, it sounds like that particular sheet is corrupt, rather than it being a problem with the VBA macros.

Try a different Excel file that has a macro in it or try creating/recording a macro yourself and saving it to prove if you can open other files with macros.

[Arthur Keith]

Thanx , on my way to try it now! I really want to get good at this programming stuff, and excel, and etc... But thanx .