×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How can i draw a revision cloud around sellected cells

How can i draw a revision cloud around sellected cells

How can i draw a revision cloud around sellected cells

(OP)
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.

RE: How can i draw a revision cloud around sellected cells

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.

RE: How can i draw a revision cloud around sellected cells

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)

RE: How can i draw a revision cloud around sellected cells

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.

RE: How can i draw a revision cloud around sellected cells

(OP)
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.



RE: How can i draw a revision cloud around sellected cells

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

RE: How can i draw a revision cloud around sellected cells

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

RE: How can i draw a revision cloud around sellected cells

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

RE: How can i draw a revision cloud around sellected cells

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

Best regards

Morten

RE: How can i draw a revision cloud around sellected cells

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources