How to copy sheet & change col headers

Hi Guys,

I have a few questions regarding excel.

[1]

I want to copy all the contents of a sheet to a new sheet .How could it be done.

[2]

How could I change the Column Headers(A,B,C,D) in a sheet to some concrete names.

[3]

How could I see all the comments I have wrote in a meaninful way...

[4]

After writing the excel document,I want to give it to others.But I dont want anyone to edit this. Is that possible.


I think thats a list now

Thanks
P

1, 2, and 3 are answered in the following macro.

For 4 - Search in Help for Protect Workbook or Protect Wroksheet

Please Login or Register  to view this content.

How should I use this code.?
Isnt there any menu items which I could use

1. Non-VBA way, right click on the tab and click Move or Copy then just decided on your options.

2. I don't believe you can actually change the A,B,C and the top of the spreadsheet. Normally row A is used for your "custom" headers.

3. You can print the comments on a separate page using the Page Setup under the File Menu (Sheets Tab)

4. Tools - Protection - Protect Sheet