LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Krista
 
Posts: n/a
Default Worksheet Protection

I currently have a large worksheet that is used by many to input data.
However I have some columns locked so the end user can not delete the
computed columns. However I need to allow the end user to add rows if
necessary. In the protection I checked off insert rows. However this
function is not working do to some of the column locks.

Example: Across the top of my worksheet I have the months listed and totals
by quarters for the year as they need to add a new row for a new customer.

I hope this makes sense and someone can offer me some help.
 
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
protection of your worksheet Timwig Excel Worksheet Functions 1 March 16th 05 05:03 PM
Prevent unhide of rows/columns w/out worksheet protection? annonymous Excel Discussion (Misc queries) 2 March 10th 05 07:23 PM
Worksheet tab protection Xlim Excel Discussion (Misc queries) 2 January 16th 05 01:34 PM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM
Seeking help for total worksheet protection Joseph Geretz Excel Discussion (Misc queries) 10 December 31st 04 06:48 PM


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"