LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Copying and renaming worksheets

Hi,

I'm new to this VBA programming, but have managed to get reasonably far with
it. But I still have one problem.
I am trying to let a user copy a sheet (to the end of the workbook, easy
enough), rename it myself in code (easy enough), and then send an existing
sheet to the end of the workbook (makes sure that my summary sheet is always
last).
Now... All my VBA code is in a module, except for some button click code in
each sheet (which calls into my module). The problem I have is that when I
copy a sheet, I need to be able to copy the buttons on the sheet, and the
code behind those buttons.

Does anyone know how I can do this? I hope I have explained it properly.

Thanks for any help given.

John Young


 
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
Renaming worksheets Teeny Excel Discussion (Misc queries) 8 August 18th 09 10:21 PM
Renaming worksheets James Excel Worksheet Functions 0 May 12th 09 11:45 PM
RENAMING WORKSHEETS LEOPARDSHIDEAWAY Excel Worksheet Functions 1 July 26th 07 10:27 PM
Renaming sheets with the same name after copying into a new workbo cdb Excel Discussion (Misc queries) 0 March 14th 06 04:25 PM
Copying and renaming a file Craig Excel Discussion (Misc queries) 1 February 24th 05 10:47 PM


All times are GMT +1. The time now is 11:39 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"