ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comments box markers (https://www.excelbanter.com/excel-discussion-misc-queries/1151-comments-box-markers.html)

JDCIWS

Comments box markers
 
How do you print markers for cells with comments?

Ron de Bruin

Hi

Look on Debra's site for information
http://www.contextures.com/xlcomments01.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"JDCIWS" wrote in message ...
How do you print markers for cells with comments?




Debra Dalgleish

The following thread has two suggested solutions:
- a macro that adds a triangle to any cell with a comment
- a picture of the worksheet


http://groups.google.com/groups?hl=e...texture s.com



JDCIWS wrote:
How do you print markers for cells with comments?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Ron de Bruin

Hi Debra

Maybe add this to your webpage

Have a nice day

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Debra Dalgleish" wrote in message ...
The following thread has two suggested solutions:
- a macro that adds a triangle to any cell with a comment
- a picture of the worksheet


http://groups.google.com/groups?hl=e...texture s.com



JDCIWS wrote:
How do you print markers for cells with comments?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




Debra Dalgleish

Hi Ron,

Good idea! I'll try to get it done this weekend.

Debra

Ron de Bruin wrote:
Hi Debra

Maybe add this to your webpage

Have a nice day



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Debra Dalgleish

Hi Ron,

Here's the link to the new section on printing comment indicators:

http://www.contextures.com/xlcomments03.html#Indicator

Debra

Ron de Bruin wrote:
Hi Debra

Maybe add this to your webpage

Have a nice day



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Ron de Bruin

Hi Debra

Only the dim line is not correct on the webpage

Dim shpCmt #0000CC Shape
Must be
Dim shpCmt As Shape

Have a nice weekend


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Debra Dalgleish" wrote in message ...
Hi Ron,

Here's the link to the new section on printing comment indicators:

http://www.contextures.com/xlcomments03.html#Indicator

Debra

Ron de Bruin wrote:
Hi Debra

Maybe add this to your webpage

Have a nice day



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




Debra Dalgleish

Thanks Ron -- it's fixed now.
Debra

Ron de Bruin wrote:
Hi Debra

Only the dim line is not correct on the webpage

Dim shpCmt #0000CC Shape
Must be
Dim shpCmt As Shape

Have a nice weekend




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Ron de Bruin

Great

It is a Superb page



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Debra Dalgleish" wrote in message ...
Thanks Ron -- it's fixed now.
Debra

Ron de Bruin wrote:
Hi Debra

Only the dim line is not correct on the webpage

Dim shpCmt #0000CC Shape
Must be
Dim shpCmt As Shape

Have a nice weekend




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com