Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default copy sheet with buttons

I have a sheet with buttons and i want to copy this sheet to a new sheet
using a macro.

I use this code:
If Not SheetExists(ListBox1.Value) Then
Sheets(ActiveSheet.Name).Visible = False
Worksheets.Add.Move After:=Worksheets(Worksheets.Count)
Set Cursheet = ActiveSheet
Cursheet.Name = ListBox1.Value
Sheets("Orgineel").Visible = True
Sheets("Orgineel").Select
Cells.Select
Selection.Copy
Sheets(ListBox1.Value).Select
Range("A1").Select
ActiveSheet.Buttons.Add(377.25, 44.25, 71.25, 26.25).Select
ActiveSheet.Buttons.Add(377.25, 82.5, 71.25, 26.25).Select
ActiveSheet.Buttons.Add(377.25, 133.5, 71.25, 26.25).Select
ActiveSheet.Paste
Range("A3").Select
Sheets("Orgineel").Visible = False
ActiveWindow.DisplayZeros = False
Else

The listboxvalue is the name of the sheet.
But it looks like all text from the original sheet is super imposed on the
new sheet,

Can someone help.

Greetings Hans


Reply
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
What keyboard has buttons of cut, copy and paste on it? rcnwrc Excel Discussion (Misc queries) 1 January 12th 06 07:02 PM
Copy buttons by rows Optitron New Users to Excel 21 August 30th 05 08:56 PM
How to copy a workbook so the buttons run the macros? - Excel Discussion (Misc queries) 4 May 15th 05 11:24 PM
Can I copy radio buttons so that the second set is independent of. pd4him Excel Discussion (Misc queries) 1 February 9th 05 12:34 AM
Do not copy buttons or macros Gbiwan Excel Programming 3 February 27th 04 03:40 AM


All times are GMT +1. The time now is 05:17 AM.

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

About Us

"It's about Microsoft Excel"