LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PUTTING VBA'S TOGETHER confused deejay Excel Worksheet Functions 5 September 1st 08 03:56 AM
Bug in Excel's (not VBA's) MOD function Jerry W. Lewis Excel Discussion (Misc queries) 10 August 30th 05 05:13 PM
Bug in Excel's (not VBA's) MOD function Jerry W. Lewis Excel Worksheet Functions 10 August 30th 05 05:13 PM
wats the best way for learning Macros, vba's etc sokevin Excel Programming 3 February 19th 04 08:27 AM
VBA's Future xnman Excel Programming 3 October 20th 03 07:04 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"