LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MWS MWS is offline
external usenet poster
 
Posts: 53
Default Copying A Worksheet Only, Excluding the Code

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing worksheet excluding rows with formulas LennyG Excel Programming 7 December 14th 04 07:49 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM
Print current worksheet excluding a few cells Daniel Lidström Excel Programming 3 September 10th 04 11:02 AM
help with excluding 0s from code scottwilsonx[_26_] Excel Programming 2 August 25th 04 02:02 PM
Problem copying worksheet containing code module Basie[_2_] Excel Programming 1 September 3rd 03 12:28 AM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"