 |
 | 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 / April 2004Keeping workbooks open
I am using data from one workbook and created drop down boxes i another. My question is - how do I get the drop down boxes to work i I close the first workbook? does the workbook always have to stay ope for the data to appear in the drop down boxes -- Message posted from http://www.ExcelForum.com yeah thats right it does. you could make a macro that copies the cells from the first workboo (eg a:a) and then pastes them into the open workbook, everytime yo open the activeworkbook. The dropdown menu will then read from thi list. HT -- Message posted from http://www.ExcelForum.com Thanks - I have to become more familiar with macros - I have never use them before - I need some lessons -- Message posted from http://www.ExcelForum.com ERuane - Get Ron DeBruin's Google add-in. Makes searching the newsgroups for macro help so much easier! I use it more than any book I've ever bought, and you get real-world lessons form people who've mastered VBA by using it every day. http://www.rondebruin.nl/Google.htm HTH Ed > Thanks - I have to become more familiar with macros - I have never used > them before - I need some lessons! > > --- > Message posted from http://www.ExcelForum.com/ |
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.