LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default How to keep hidden columns hidden using protection

I am trying to hide columns on a sheet and not allow user to unhide them.
When I go into a blank workbook and hide columns and protect the sheet, the
hidden columns can not be unhidden. In the file I am working on, the hidden
columns on a protected sheet can still be unhidden. I checked the format
column box in the password protection box. All cells in the column have
locked checked when you go into format cells.

Thanks
Dave
 
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
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns Rob the Winer Excel Worksheet Functions 7 October 5th 05 03:41 AM
Columns FemIce Excel Discussion (Misc queries) 1 September 28th 05 09:29 AM
How do I unhide columns previously hidden Maureen Excel Discussion (Misc queries) 3 September 7th 05 06:13 PM
excel macros truncating tabs for hidden columns. SharanS Excel Discussion (Misc queries) 0 February 17th 05 05:05 AM
I can't unhide 3 columns previously hidden Kozul Excel Discussion (Misc queries) 1 December 3rd 04 05:15 AM


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