Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Revision clouds?

Is there anyway to easily make revision clouds around specific cells/
groups of cells in excel?

Thanks,
David
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Revision clouds?

Is this what you are looking for? The location may need some minor adjustments

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 4/23/2008 by Joel Warburg
'

'
Set Cloud_Loc = Range("B7")
Cloud_Height = 48#
Cloud_Width = 72#
Cloud_Left = Cloud_Loc.Left + Cloud_Width
Cloud_Top = -1 * (Cloud_Loc.Top + Cloud_Height)


ActiveSheet.Shapes.AddShape(msoShapeCloudCallout, _
Cloud_Left, Cloud_Top, Cloud_Width, Cloud_Height).Select

End Sub

" wrote:

Is there anyway to easily make revision clouds around specific cells/
groups of cells in excel?

Thanks,
David

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Revision Number for an Add-In RST Excel Programming 6 October 31st 06 07:41 PM
Revision kbkst via OfficeKB.com Excel Discussion (Misc queries) 4 February 17th 06 07:12 PM
Macro Revision needed HJ Excel Programming 5 May 27th 05 09:57 PM
Revision Number John Excel Worksheet Functions 2 December 14th 04 05:29 PM
Notation on Revision of Projects Tim Childs Excel Programming 2 January 20th 04 10:27 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"