Security Issue

[Guest]

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?

 

[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

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?

 

[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

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?