Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jim
 
Posts: n/a
Default How do i delete a row in a excel worksheet that is protected

I have an excel worksheet that contains all of our prices, the sales group
wants to take a copy of that and create proposals, the sheet is password
protected so no one can change the prices, the problem is, the sales group
want to delete unneeded rows of information, how can i allow them to do that
if its protected
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Jim

If you and the sales people are using 2002/2003 you can mark this option when you protect your sheet.
It is also possible with code in all versions, post back if you want a example.




--
Regards Ron de Bruin
http://www.rondebruin.nl



"jim" wrote in message ...
I have an excel worksheet that contains all of our prices, the sales group
wants to take a copy of that and create proposals, the sheet is password
protected so no one can change the prices, the problem is, the sales group
want to delete unneeded rows of information, how can i allow them to do that
if its protected



  #3   Report Post  
jim
 
Posts: n/a
Default

Hi Ron, please give me an example, i am having trouble with this jim

"Ron de Bruin" wrote:

Hi Jim

If you and the sales people are using 2002/2003 you can mark this option when you protect your sheet.
It is also possible with code in all versions, post back if you want a example.




--
Regards Ron de Bruin
http://www.rondebruin.nl



"jim" wrote in message ...
I have an excel worksheet that contains all of our prices, the sales group
wants to take a copy of that and create proposals, the sheet is password
protected so no one can change the prices, the problem is, the sales group
want to delete unneeded rows of information, how can i allow them to do that
if its protected




  #4   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Jim

Try this on a test workbook first

Protect your worksheets with code with userfaceonly like this
Place this in the Thisworkbook module.

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel

Private Sub Workbook_Open()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Protect "ABCD", , , userinterfaceonly:=True
Next sh
End Sub

All sheets are protected now with the password "ABCD" and if you add a button on your sheet
with a macro like this

Sub delrows()
Selection.EntireRow.Delete
End Sub

The user can delete rows





--
Regards Ron de Bruin
http://www.rondebruin.nl



"jim" wrote in message ...
Hi Ron, please give me an example, i am having trouble with this jim

"Ron de Bruin" wrote:

Hi Jim

If you and the sales people are using 2002/2003 you can mark this option when you protect your sheet.
It is also possible with code in all versions, post back if you want a example.




--
Regards Ron de Bruin
http://www.rondebruin.nl



"jim" wrote in message ...
I have an excel worksheet that contains all of our prices, the sales group
wants to take a copy of that and create proposals, the sheet is password
protected so no one can change the prices, the problem is, the sales group
want to delete unneeded rows of information, how can i allow them to do that
if its protected






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
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 09:51 PM
Excel should not delete document after trying to send email 4rs Excel Discussion (Misc queries) 0 January 14th 05 05:39 AM
How do I show the last saved date in an Excel worksheet? mgriffie Excel Worksheet Functions 1 January 5th 05 09:46 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 01:53 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 08:12 PM


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