Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Background I have a worksheet labelled "Populate Scorecard", that has an interface/GUI and several calculations run upon the "activate" event. Issue There is now a need to present the user with a screen/GUI, giving them the option of whether or not they want to copy the "Populate Scorecard"worksheet. I'm copying the worksheet via: Sheets("Populate Scorecard....").Select Sheets("Populate Scorecard....").Copy After:=Sheets(5) Since the sheets is copied, when the user then activates the copied sheet (ie "Populate Scorecard (2)"), the calculations are rerun, which I must prevent. Question Is there a way to systematically copy a worksheet, without the associated code also being copied? Any responses, or alternative approaches, will be greatly appreciated. Thanks In Advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing worksheet excluding rows with formulas | Excel Programming | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Print current worksheet excluding a few cells | Excel Programming | |||
help with excluding 0s from code | Excel Programming | |||
Problem copying worksheet containing code module | Excel Programming |