create a button event

[joe12613]

I have a spreadsheet having a command button. Once I click on this button , This need to create a separate workbook and need to insert ‘following code in the sheet1 under Worksheet_Change event. Would it possible ?

Please Login or Register  to view this content.

Any help is appreciated…

[royUK]

The simplest way is to copy the sheet to a new workbook. The code will copy with it.

[joe12613]

The simplest way is to copy the sheet to a new workbook. The code will copy with it.

Thanks for quick reply, The main requirement is to create around 15 similar sheets for each employee in everyweek. I thought this can be automated by doing this.

It would be great if you could throw some light on this.

Jophy

[Leith Ross]

Hello Jophy,

Copy the code below into a Standard VBA module. This will automatically insert the Worksheet_Change event procedure, and your macro into Sheet1 of each Open Workbook. You will need to add a Reference to the Microsoft Visual Basic for Applications Extensibility library before this macro will run.

1. In the Visual Basic Editor go to Tools > References...
2. Scroll through the dialog box until you find Microsoft Visual Basic for Applications Extensibility
3. Click the Check Box to the left of the entry and click OK
4. Save your project

Please Login or Register  to view this content.

Sincerely,
Leith Ross