 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Copying code
New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 What is "doesn't work"? Error message? Incorrect results? Nothing? If you copied a Function from Chip's site and placed it in your Personal.xls you have to preface the Function like so or you will get the #NAME? error in the cell. =Personal.xls!Function() If not a Function, but a Sub then tell us which one from Chip's site. Gord Dibben MS Excel MVP >New to VBA so ... >I have copied some of the great code from CPearson.com. If I open a new [quoted text clipped - 6 lines] >Thanks. >WAL50 "doesn't work" is a frequently used term meaning "this should be working but I have no idea why it doesn't". Anyway, you resolved my problem (#Name). Thanks. WAL50 > What is "doesn't work"? > [quoted text clipped - 20 lines] > >Thanks. > >WAL50 > "doesn't work" is a frequently used term meaning "this should be working > but > I have no idea why it doesn't". That's the obvious part > Anyway, you resolved my problem (#Name). Thats what was wanted in the first place > Thanks. > WAL50 Glad it works Steve >> What is "doesn't work"? >> [quoted text clipped - 31 lines] >> >Thanks. >> >WAL50 In addition, the frequently used term "doesn't work" is a non-descriptive term which is of absolutely no use to anyone attempting to troubleshoot a problem. I guessed and this time was lucky. Gord >"doesn't work" is a frequently used term meaning "this should be working but >I have no idea why it doesn't". Anyway, you resolved my problem (#Name). [quoted text clipped - 25 lines] >> >Thanks. >> >WAL50 Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.