If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel worksheet
Is there a formula, or function that will,
In a spreat sheet, if there is a section in the sheet that does not pertain to some of the users of the spreadsheet, therefore left blank (or otherwise formulated, if there is one) is there a way to delete the entire row(s) in the sheet? (other than the non-experienced users to delete rows manually). |
#2
|
|||
|
|||
Excel worksheet
On Jul 31, 1:56 pm, boschuster50
wrote: Is there a formula, or function that will, In a spreat sheet, if there is a section in the sheet that does not pertain to some of the users of the spreadsheet, therefore left blank (or otherwise formulated, if there is one) is there a way to delete the entire row(s) in the sheet? (other than the non-experienced users to delete rows manually). No formula or function can delete anything. And if you delete a row because "John" is looking at it, how will you get it back when you look at the workbook, again? Sounds like you need to use Protect Sheet, Hide, Lock Cell and some other security methods if some people are not allowed to see everything. Although you should know that Excel's security is not very good against high-end users. Another alternative is probably to use VBA to Hide (not delete) certain data based on the user that opens the file. At least, I'm assuming VBA can reference the user. But I couldn't write that for you, need someone a little more advanced. |
#3
|
|||
|
|||
Excel worksheet
It's not that the user's are not supposed to see information, it is that the
user's do not need all of the rows included in the spread sheet. I am asking for another gentleman in the office, personally I don't see the difficulty in deleting rows. Thanks for your response. "Spiky" wrote: On Jul 31, 1:56 pm, boschuster50 wrote: Is there a formula, or function that will, In a spreat sheet, if there is a section in the sheet that does not pertain to some of the users of the spreadsheet, therefore left blank (or otherwise formulated, if there is one) is there a way to delete the entire row(s) in the sheet? (other than the non-experienced users to delete rows manually). No formula or function can delete anything. And if you delete a row because "John" is looking at it, how will you get it back when you look at the workbook, again? Sounds like you need to use Protect Sheet, Hide, Lock Cell and some other security methods if some people are not allowed to see everything. Although you should know that Excel's security is not very good against high-end users. Another alternative is probably to use VBA to Hide (not delete) certain data based on the user that opens the file. At least, I'm assuming VBA can reference the user. But I couldn't write that for you, need someone a little more advanced. |
Thread Tools | |
Display Modes | |
|
|