ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to select all comments in spreadsheet at once, to re-size all (https://www.excelbanter.com/excel-worksheet-functions/184925-how-select-all-comments-spreadsheet-once-re-size-all.html)

Trish

How to select all comments in spreadsheet at once, to re-size all
 
In excel 2003, is it possible to select all comments in order to re-size them
all at once? If so, how?

Max

How to select all comments in spreadsheet at once, to re-size all
 
"Trish" wrote:
In excel 2003, is it possible to select all comments in order to re-size them
all at once? If so, how?


Try Debra's page at:
http://www.contextures.com/xlcomments03.html#Resize
Resize Comments - 2 subroutines available:
Resize all comments on the active sheet (by Dana DeLouis)
Resize all comments in the selected area (by Dave Peterson)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


All times are GMT +1. The time now is 07:59 AM.

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