LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bettergains
 
Posts: n/a
Default Hiding columns and custom views problem

Hello:
I have defined 6 views in modules that define views. The views are simply
hiding or showing columns based on a value in a hidden row. These columns
are also grouped in outlines. I am having issues with one of the views which
is spitting out the "can't move objects off sheet" error. I already have
code in the workbook that autosets the "size with cells" property of inserted
comments.

Are there some caveats with hiding/showing columns which are grouped? Are
there limits to the number of columns that can be manipulated in this way? My
sheet has 150 columns. I would like to be able to show only 20, but that
doesn't seem to be working without this error occurring.

Appreciate it, as always, Bettergains
 
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



All times are GMT +1. The time now is 07:19 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"