View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBARookie VBARookie is offline
external usenet poster
 
Posts: 1
Default 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