PC Review


Reply
Thread Tools Rate Thread

Cannot hide columns in Excel

 
 
=?Utf-8?B?Sm9obiBKb2hucw==?=
Guest
Posts: n/a
 
      28th Feb 2006
I find the following error message whenever I try to hide certain columns in
one
of my excel workbooks (through macro).
"Unable to set the Hidden Property of the Range Class. Error=1004"
This happens after hiding a few columns. When I try further to hide
manually, the
error message is
"Cannot shift objects off sheet"
and I cannot hide. Can sombody please help me to (E-Mail Removed) ?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q0xS?=
Guest
Posts: n/a
 
      28th Feb 2006
First, I would try to run the file on another computer to isolate is the
trouble is within the file itself, or within your installation of Excel.

HTH
Vaya con Dios,
Chuck, CABGx3



"John Johns" wrote:

> I find the following error message whenever I try to hide certain columns in
> one
> of my excel workbooks (through macro).
> "Unable to set the Hidden Property of the Range Class. Error=1004"
> This happens after hiding a few columns. When I try further to hide
> manually, the
> error message is
> "Cannot shift objects off sheet"
> and I cannot hide. Can sombody please help me to (E-Mail Removed) ?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
To retrieve hide columns after u saved the excel doc EL Microsoft Excel Misc 2 22nd Feb 2009 11:48 PM
how do i hide columns in excel so no one can open them. =?Utf-8?B?YnJpYW5i?= Microsoft Excel Misc 3 21st Nov 2006 11:21 PM
columns to be hide in Excel. =?Utf-8?B?Sk9SR0UgT1JUSVo=?= Microsoft Excel Crashes 1 2nd Jul 2005 02:17 PM
Getting Excel error when trying to hide columns. Why? =?Utf-8?B?TUNsYXJr?= Microsoft Excel Misc 1 28th Apr 2005 11:28 PM
Excel button :: Filter columns by value - possible? Additionally, hide certain columns Microsoft Excel Programming 4 28th Dec 2004 07:44 PM


Features
 

Advertising
 

Newsgroups
 


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