Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Hiding columns in a protected sheet

If you can't do it via the user interface and you can't do it via a macro, I
don't know what's left.

wtebra wrote:

@ muddan madhu

I already try'd your solution. But this is not the answer, it is indeed
possible to moddify the column with, but not to hide columns.

@ Dave Peterson

Creating a macro is also not possible. I'm trying to make a planning
document were people can hide or unhide columns containing weeks of the year.
Parhaps there is another solution/method for my problem.

"wtebra" wrote:

I'm working on a sheet with some protected cells. I want make it possible
that poeple can hide some columns but not the protecten cels that are in the
same columns. I try'd it, but when I select the columns including the
protected cells the option to hide the columns is gray. Is something like
that possible?


--

Dave Peterson
Reply
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, error message says cannot shift objects off sheet JORGE ORTIZ Excel Discussion (Misc queries) 11 August 19th 08 10:34 AM
Hiding rows while sheet is protected burnsbyrne Excel Discussion (Misc queries) 5 August 22nd 06 08:40 PM
Hiding columns, custom views, protected sheet Ian Excel Discussion (Misc queries) 0 May 4th 06 09:59 AM
TEX TO COLUMNS PROTECTED SHEET Jeracho Excel Discussion (Misc queries) 1 August 26th 05 09:51 PM
TEXT TO COLUMNS PROTECTED SHEET Jeracho Excel Discussion (Misc queries) 1 August 26th 05 09:40 PM


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