Excel VBA's are there but not recognized as macros so they can't b
When I develop a spreadsheet using VBA's on using Excel 2002 and then open
the spreadsheet on computer using Excel 2003 the VBA's don't work.... I can
see the code and edit it in the VBA editor, save the files and re-open it and
its there but when I go to run the marco the list of macros is all blank. If
I try to creat a name using a sub name in the program I have written the
Excel me there is a name conflict so it knows the sub exists! I have macros
enabled and security set to low to get them to work and that did not help
either. If I retype (using a different sub name) the same exact macro in the
same module it is are recognized and it works.
Going from Excel 2003 to Excell 2002 works fine.
SInce I am just learning learning VBA from scratch, having to figure out
things like this on myself has been mpossible. Any suggestions
|