Excel comment

**craig mullen** · 02-08-2007, 01:18 PM

Hi all

I am trying to find out if it is possible to do the following

I have an excel sheet with comments in is it possible to print the comments with the cell content also. I know you can print comments at the end of the document but this does not include the figure/s in the cell

Can anyone help
Craig

**VBA Noob** · 02-08-2007, 01:23 PM

Hi,

This link should help

http://www.contextures.com/xlcomment...ml#CopyToSheet

VBA Noob

**craig mullen** · 02-08-2007, 03:38 PM

Cheers VBA Noob

dont now how to use macros

Is there an easier way?

**VBA Noob** · 02-08-2007, 03:41 PM

It's very easy and quick

Press Alt + F11
Select Insert > Module

Select the below code and paste in. Close Editor

Then press

ALT + F8 and select Showcomments macro to run

Please Login or Register  to view this content.

VBA Noob

**craig mullen** · 02-08-2007, 04:23 PM

Great stuff

Its a breeze

another Q

now im really getting into this how can I add alignment to the results sheet. I have already changed the cell names in the marco editor but would really like to align the cells and widen if poss

Sorry to be a pain
Craig

**VBA Noob** · 02-08-2007, 04:36 PM

Try

Please Login or Register  to view this content.

VBA Noob

**craig mullen** · 02-09-2007, 05:35 AM

Thanks again VBA

I have only 1 more question if possible

Can the marco be run for the entire workbook rather than a sheet

Thanks again U are a great help

craig

Excel comment

LinkBack

Thread Tools

Rate This Thread

Display

Excel comment

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions