 |
 | 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 / March 2008Possible to access macro in 1 workbook from any open workbook?
I have a macro that I run by hitting Ctrl-M. It's in Workbook A. I'd like it to be able to be run from any open workbook. Is there a way to do this? If you add the macro to your personal.xls workbook, you can run it any time you have Excel open. Check out http://www.rondebruin.nl/personal.htm HTH, JP On Mar 18, 9:23 am, "Ex...@shoenfeltconsulting.com" <ex...@shoenfeltconsulting.com> wrote: > I have a macro that I run by hitting Ctrl-M. It's in Workbook A. I'd > like it to be able to be run from any open workbook. Is there a way > to do this? Put it in your Personal.xls workbook. The personal.xls workbook opens hidden everytime that you open XL  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >I have a macro that I run by hitting Ctrl-M. It's in Workbook A. I'd > like it to be able to be run from any open workbook. Is there a way > to do this?
|
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.