Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Excel should not delete document after trying to send email | Excel Discussion (Misc queries) | |||
How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |