Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about creating a template
I am trying to create a template for my boss that is used to track Claim
Reviews for the health care industry. My boss is very computer challenged, so I need a form that she can type answers in and it transfers to a spreadsheet. It has to be protected, she is one to push the red button to see what it may do, even after telling her not to push the button. Any suggestions for getting started? |
#2
|
|||
|
|||
I wanted something similar. I would make a form for them to fill it out and
then make it "read only" so she has to do an F12 and save-as every time. |
#3
|
|||
|
|||
how I do I make the form?
" wrote: I wanted something similar. I would make a form for them to fill it out and then make it "read only" so she has to do an F12 and save-as every time. |
#4
|
|||
|
|||
Excel has a built in Data|Form that may work ok for you and your boss. In fact,
you could make it so that she only sees that Data|Form dialog... 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 The only way for your boss to see the data is through that button. (Unless she learns how to unhide a worksheet.) If that's close, but not quite it, maybe John Walkenbach's enhanced dataform at: http://j-walk.com/ss/dataform/index.htm may be sufficient And if you want to create your own, then Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html bmw121199 wrote: I am trying to create a template for my boss that is used to track Claim Reviews for the health care industry. My boss is very computer challenged, so I need a form that she can type answers in and it transfers to a spreadsheet. It has to be protected, she is one to push the red button to see what it may do, even after telling her not to push the button. Any suggestions for getting started? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a template for creating outline in Excel as opposed to W | Excel Worksheet Functions | |||
Template question | Excel Discussion (Misc queries) | |||
Basic Template Question | Excel Discussion (Misc queries) | |||
Template question | Excel Discussion (Misc queries) | |||
Template Question | Excel Discussion (Misc queries) |