How can i draw a revision cloud around sellected cells

[aar001]

Hi everybody,

I need your experience an help with this noob. I want to draw revision clouds for engeneering docs in excel. I read a lot but nothing.

in thise post Macro or routine for Rev Cloud talks about it, but i dont understand that macro or i use it bad, it make´s me the ugly cloud shape.

i need to do something like the attached document, i dont care if its with macro, with VB, with add-ins o options-toolbar or if i need to use autocad.

 

[macmet]

I'm not sure what version of Excel you have, but I have 2007 and in my "basic shapes" I have what looks like a revision cloud. Just go to Insert, Shapes and it is under "Basic Shapes".

I've never used it before. I assume you could play around with the fill and line colour too.

 

[aar001]

I forgot tell i use Excel 2010. i will show what i get. with the marcro attached in the doc.

 

[IsaacStructural]

The cloud needs to be in excel and not in a printout? if printout you could print to pdf and add the clouds easily.

M.S. Structural Engineering
Licensed Structural Engineer and Licensed Professional Engineer (Illinois)

 

[structSU10]

Yea, i dont understand the need for clouds to appear dynamically in the spreadsheet - seems more annoying than anything. I would think clouds would be a post-process thing like adding it as a basic shape of in a pdf as said above.

 

[aar001]

In my work i make a lot of revisions for the client whit a lot of similar documents like the attached, so its easy for me and i have a better control of the changes i did. I will attach an example for another company of what i do and for what i need those revisions clouds. PDF files I use it only for provide to client and not for my use thats why i prefer use revision clouds on excel and not on PDF.

So I said why the poeple of that other company can do it and i can´t.

 

[IFRs]

Insert - Shapes - Cloud
Or make one in Word and copy/paste

 

[MortenA]

My guess is thats its done manually (dont you just hate the clients sometime). But maybe somebody will be clever enough to make a macro that could do it?

Best regards

Morten

 

[zuccus]

I had a similiar problem and just setup a macro with a worksheet change event to highlight the cell yellow if it changed. Then I had a button at the top to put it back to automatic to "reset" the sheet.

Made life much easier to track what the changes were.

Zuccus

 

[MortenA]

zuccus, i guess you were lucky - some clients wont let their consultants get by that easily

Best regards

Morten

 

[aar001]

What zuccus said its an easy way but not to formal, and make revision clouds and a formal work, means the professionalism of us.