 |
 | 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 / June 2007Problem to recognize macro
I am using a macro to direct the out print to two different printers and that is ok, But I am using a button in the sheet for it and when I am saving it as a template and then are trying to use it I get the message cant find macro “sheet1!macro1” for example. The problem appers when I am saving it as a template. Instead of using a button from the Forms toolbar, use a commandbutton from the Control Toolbox Toolbar. And move your code to that button's _click event. You may have to modify the code a bit, too. > I am using a macro to direct the out print to two different printers and that > is ok, > But I am using a button in the sheet for it and when I am saving it as a > template and then are trying to use it I get the message cant find macro > âsheet1!macro1â for example. The problem appers when I am saving it as a > template.  SignatureDave Peterson Thanks Dave Peterson It helpt me and everything is working good. I am sorry that my question is on two places but I had forgotten to write my e-mail address so I thought it was not published /Stefan > Instead of using a button from the Forms toolbar, use a commandbutton from the > Control Toolbox Toolbar. [quoted text clipped - 9 lines] > > “sheet1!macro1†for example. The problem appers when I am saving it as a > > template.
|
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.