Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
NH
 
Posts: n/a
Default Add or Delete Rows in Protected worksheets

I am working on a spreadsheet with some protected cells and was told that I
might insert or delete as many rows between a range (e.g. line 10 to line
20).

I got no problem to insert rows by selecting ROWS from the INSERT menu, but
I couldn't use the "Insert Row" icon from the toolbar since it was disable
(the icon in gray color). However, I couldn't find a way to delete the rows
I just inserted.

Question:
1) Is it possible that the "Insert Row" icon can be functionated in the
protected spreadsheet?
2) Is there a method to delete rows in the protected spreadsheet?
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
Unhiding Protected Rows and Columns? is it possible? guilf Excel Discussion (Misc queries) 1 July 26th 05 06:13 PM
delete extra columns and rows matt charlton Excel Discussion (Misc queries) 1 June 7th 05 08:46 PM
delete rows from multiple worksheets dckrause Excel Worksheet Functions 1 June 1st 05 03:24 AM
How to delete rows when List toolbar's "delete" isnt highlighted? Linda Excel Worksheet Functions 1 May 26th 05 08:39 PM
How do i delete a row in a excel worksheet that is protected jim Excel Worksheet Functions 3 March 7th 05 09:05 PM


All times are GMT +1. The time now is 07:27 PM.

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"