Please Help.. copy,formatting issues
 

This is a re-post because I didn't get any response before.

I am using Excel97 (ugh!) and I am very new to VBA so I am stuck.
I have a couple problems:

1. I am trying to copy my worksheet, which contains buttons, to a ne
worksheet and make the buttons on the new worksheet do exactly what th
original buttons do. When I run my code now the buttons on the ne
sheet don't do anything.

2. I am trying to figure out how to center an uploaded photo (uploade
by user form) over a cell. It is currently ending up at the far left o
cell J12.

3. I would like to hide my master worksheet (that I use to copy to th
new worksheet when a button is pressed) so users don't know it i
there

--
Message posted from http://www.ExcelForum.com