Prev Previous Post   Next Post Next
  #1   Report Post  
belony
 
Posts: n/a
Default Hiding Columns


Hi,
I am new to this forum. I hope someone can help me.
I have a workbook to which I add a sheet every pay period. Actually, I
copy the sheet from the previous week and make a new, additional sheet
at the end of the workbook.
I use these sheets for batching the current payroll information and
link past columns to new. I do not remove any old info from the new
copied sheet, but I add 10 new columns to each sheet each time I copy.
I tell you all of this in case it helps with my problem.
My new sheet will not allow me to hide the columns I don't need to see.

The Error message is "CANNOT SHIFT OBJECTS OFF SHEET".
I have been hiding columns for years and years and have never gotten
any error message, much less on like this. Can anyone out there help??
Thanks so much.


--
belony
------------------------------------------------------------------------
belony's Profile: http://www.excelforum.com/member.php...o&userid=24311
View this thread: http://www.excelforum.com/showthread...hreadid=379174

 
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
Hiding columns and custom views problem Bettergains Excel Discussion (Misc queries) 2 April 12th 05 11:48 PM
Hiding columns Adam Excel Discussion (Misc queries) 2 March 31st 05 05:07 PM
hiding columns automatically dave glynn Excel Discussion (Misc queries) 2 February 1st 05 06:36 PM
hiding columns automatically dave glynn Excel Discussion (Misc queries) 0 February 1st 05 06:15 PM
Hiding columns based on user/password jmatchus Excel Worksheet Functions 0 January 17th 05 06:49 PM


All times are GMT +1. The time now is 03:09 AM.

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"