Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing an entry from another worksheet
I have a spreadsheet with data that I have protected. The data is entered via
another worksheet then sent over via a macro. I have some else using this and really don't want them messing with the database spreadsheet. My problem is if they make an incorrect entry how can I pull that entry back out again for them to change and then resubmit. Can I write a macro for this maybe using an invoice number as an identifier? I would greatly appreciate any direction. I know this sounds like something for Access. Long story why not! Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
|
|||
|
|||
You may want to look at Data|Form. It has options that can do some of what you
want. But if you really want more control (and not allow the user to access the real data), I think you'll need a userform--kind of like the one John Walkenbach has at: http://j-walk.com/ss/dataform/index.htm And if you want to learn a bit about userforms, visit Debra Dalgleish's site: http://www.contextures.com/xlUserForm01.html Jennifer wrote: I have a spreadsheet with data that I have protected. The data is entered via another worksheet then sent over via a macro. I have some else using this and really don't want them messing with the database spreadsheet. My problem is if they make an incorrect entry how can I pull that entry back out again for them to change and then resubmit. Can I write a macro for this maybe using an invoice number as an identifier? I would greatly appreciate any direction. I know this sounds like something for Access. Long story why not! Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer -- Dave Peterson |
#3
|
|||
|
|||
Thank you Dave.
Yeah I don't want to use Data\Form because I really don't want them to have full access to that data. And the way I understand the forms it only works on the worksheet. I will check out the sites you suggested. Thank you! "Dave Peterson" wrote: You may want to look at Data|Form. It has options that can do some of what you want. But if you really want more control (and not allow the user to access the real data), I think you'll need a userform--kind of like the one John Walkenbach has at: http://j-walk.com/ss/dataform/index.htm And if you want to learn a bit about userforms, visit Debra Dalgleish's site: http://www.contextures.com/xlUserForm01.html Jennifer wrote: I have a spreadsheet with data that I have protected. The data is entered via another worksheet then sent over via a macro. I have some else using this and really don't want them messing with the database spreadsheet. My problem is if they make an incorrect entry how can I pull that entry back out again for them to change and then resubmit. Can I write a macro for this maybe using an invoice number as an identifier? I would greatly appreciate any direction. I know this sounds like something for Access. Long story why not! Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer -- Dave Peterson |
#4
|
|||
|
|||
I put some data on Sheet1 (in A1:G25 -- just test data).
I protected sheet1 with a password (hi) and then hid sheet1. I put a button from the forms toolbar on Sheet2. And assigned that button a this macro: Option Explicit Sub testme() Dim wks As Worksheet Set wks = Worksheets("Sheet1") With wks .Unprotect Password:="hi" Application.DisplayAlerts = False .ShowDataForm Application.DisplayAlerts = True .Protect Password:="hi" End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Jennifer wrote: Thank you Dave. Yeah I don't want to use Data\Form because I really don't want them to have full access to that data. And the way I understand the forms it only works on the worksheet. I will check out the sites you suggested. Thank you! "Dave Peterson" wrote: You may want to look at Data|Form. It has options that can do some of what you want. But if you really want more control (and not allow the user to access the real data), I think you'll need a userform--kind of like the one John Walkenbach has at: http://j-walk.com/ss/dataform/index.htm And if you want to learn a bit about userforms, visit Debra Dalgleish's site: http://www.contextures.com/xlUserForm01.html Jennifer wrote: I have a spreadsheet with data that I have protected. The data is entered via another worksheet then sent over via a macro. I have some else using this and really don't want them messing with the database spreadsheet. My problem is if they make an incorrect entry how can I pull that entry back out again for them to change and then resubmit. Can I write a macro for this maybe using an invoice number as an identifier? I would greatly appreciate any direction. I know this sounds like something for Access. Long story why not! Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Formatting a worksheet for data entry | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |