Spreadsheet per user

Amorous

New Member
Joined
Aug 19, 2011
Messages
4
I have an Excel Spreadsheet for Field Workers to enter their Bonuses. The sheet gets printed out and filed. I want each of them to open up their own spreadsheet and make it password protected per user. Do you know of any software or another method on how to accomplish this? Note: This is going to be done from one computer. Im trying to avoid creating a separate AD account per user. I want this all on the same generic login.

or would it be easier just to give each user an account on the PC so excel files wont be all over the place.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Welcome to the Forum,

First thing to do is create your spreadsheet and then Save it as a Template then each user can create a copy of the Spreadsheet based on your Template, they then simply fill it in, if you want Password Protection then give them some basic instructions, such as adding Comments behind some cells.
 
Upvote 0

Forum statistics

Threads
1,224,566
Messages
6,179,551
Members
452,927
Latest member
rows and columns

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top