Some Kind of Comment Box

mbunting

New Member
Joined
Nov 24, 2010
Messages
41
My old business partner thought comment boxes were a great idea. He is gone and I have these boxes that pop up when you are in a cell. However, they are not normal Excel comment boxes. I don't know what they are called, I can't edit or delete them. I'd prefer to get rid of them all together but don't know how??
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Do you have any code in the workbook?
 
Upvote 0
I'd suspect they are data validation messages. Select one of the cells where they appear, select the Data tab, then Data validation and look at the Input message tab.
 
Upvote 0
RoryA,

THANKS!! You were correct, they are data validation messages. Is there a way to clear all of them from a worksheet in mass or will I have to do them one at a time?
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top