Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Shawn
 
Posts: n/a
Default Code to delete all comment boxes

I have a code that automatically turns on a comment box function that will
cause any change on a sheet someone makes to include a comment box with date
and time etc.

I need a code that will delete all comment boxes on a page.


--
Thanks
Shawn
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Delete them totally???

activesheet.cells.clearcomments



Shawn wrote:

I have a code that automatically turns on a comment box function that will
cause any change on a sheet someone makes to include a comment box with date
and time etc.

I need a code that will delete all comment boxes on a page.

--
Thanks
Shawn


--

Dave Peterson
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
Why oh why are my comment boxes changing shape? Marc New Users to Excel 1 April 1st 05 03:54 AM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
Cell comment boxes shouldn't change size/shape unless changed by u sam Excel Discussion (Misc queries) 1 March 3rd 05 05:23 PM
Comment Boxes Steved Excel Worksheet Functions 2 January 25th 05 09:55 PM
How to resize a comment box, by embedding code into a function? JJ Excel Worksheet Functions 13 November 16th 04 08:44 PM


All times are GMT +1. The time now is 09:15 PM.

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

About Us

"It's about Microsoft Excel"