cell comments, hiding columns, "Cannot shift objects off sheet"

[zxcv]

I have a worksheet with many cell comments and the users have a
function where they can dynamically decided which columns to hide.
The problem is that when cells near the ones with comments are hidden
they can get the "Cannot shift objects off sheet" error.

Other similar posts here have suggested changing the comment
properties to "Move and size with cells" and this stops the run-time
error but collapses the comment to make it useless.

I have tried using the "Move but don't size with cells" option and
this works most of the time but still causes the error when the cell
is in a column close to the right edge and hiding a column will cause
it to go over.

Any ideas?

 

[Jim Cone]

This may seem flippant but that's not my intent...
your best bet is probably to redesign your application to eliminate use of the columns at the edge of the worksheet.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(sorting add-in)

..
..
..

"zxcv"
<[email protected]>
wrote in message
I have a worksheet with many cell comments and the users have a
function where they can dynamically decided which columns to hide.
The problem is that when cells near the ones with comments are hidden
they can get the "Cannot shift objects off sheet" error.

Other similar posts here have suggested changing the comment
properties to "Move and size with cells" and this stops the run-time
error but collapses the comment to make it useless.

I have tried using the "Move but don't size with cells" option and
this works most of the time but still causes the error when the cell
is in a column close to the right edge and hiding a column will cause
it to go over.

Any ideas?