Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 2nd, 2012, 03:31 PM
Registered User
 
Join Date: Apr 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default help in how to copy macro in new added sheet

hello
iam using it with new module to add new sheet with speicfic name
its ok but the vba code not run on the new added sheet so the table doesnot change
i have problem here
can u help me ?
there are a description in the workbook i attached

and the file and the description and comments exists in this workbook on this link

Last edited by zmhnk; April 7th, 2012 at 08:28 AM..
 
Old April 9th, 2012, 10:22 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

There are various ways to add code to the Workbook

Programmatically add macro to Excel Workbook using VBA

Add Macro to Workbook programatically using Excel VBA

The second one might be close to you

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a Macro for Compare and copy data from one sheet to another sheet in Excel. katnam21 Excel VBA 1 January 29th, 2012 12:09 PM
Open Workbook,Copy Sheet,Move Sheet, Close/Save ptrussell2009 Excel VBA 0 June 13th, 2008 02:28 PM
How to run Macro on entry to new sheet? Wazar Excel VBA 4 May 16th, 2007 08:35 AM
variable sheet for Macro stealthdevil Excel VBA 11 May 11th, 2007 02:30 PM
Show Sheet after running macro sridevi Excel VBA 2 November 5th, 2004 08:18 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.