Security Issue

R

rnieland

How can I force a person to log on or sign on before they can use a tab or spreadsheet. I'm using excel as a cost/price calculator for my customer service people. I want to be able to identify who is using the sheet, at what time and to show customer service reps name on a quote sheet so as to identify them as the person doing the quote for the customer. Can anyone help?
 
F

Frank Kabel

Hi
though you could mimic this with VBA IMHO Excel is not the right tool
for this as for example if the user disables macros this won't work
anymore

--
Regards
Frank Kabel
Frankfurt, Germany

rnieland said:
How can I force a person to log on or sign on before they can use a
Click to expand...
tab or spreadsheet. I'm using excel as a cost/price calculator for my
customer service people. I want to be able to identify who is using the
sheet, at what time and to show customer service reps name on a quote
sheet so as to identify them as the person doing the quote for the
customer. Can anyone help?
 
J

Jos Vens

Hi,


I have almost the same problem. I solved it like this:

I hide the sheet where the input comes (xlVeryHidden) and use a
startup-sheet. If people disable macro's, they only see the startup, if
they enable macro's, I popup a form (workbook.open event) and after the
password, I unhide the sheet with data. You can then store a username in a
log-sheet.

Regards,
Jos Vens

rnieland said:
How can I force a person to log on or sign on before they can use a tab or
Click to expand...
spreadsheet. I'm using excel as a cost/price calculator for my customer
service people. I want to be able to identify who is using the sheet, at
what time and to show customer service reps name on a quote sheet so as to
identify them as the person doing the quote for the customer. Can anyone
help?
 
Top