PDA

View Full Version : Multiple users



Emoncada
05-03-2007, 08:50 AM
Is it possible to do this.
I want to create a spreadsheet with three (3) or four (4) worksheets.
Each work sheet would have a different Form.
But I want to know If I can have multiple users using this spreadsheet at the same time?

If So Can I have a security type of login. So if User1 logs in he can only see sheet1.
If User2 logs in He can only see Sheet2.
If User 5 logs in He can see both Sheet1 and Sheet2.

This is a lot. I hope someone can help or point me into the right direction.

Ken Puls
05-03-2007, 11:55 AM
While theoretically possible with a Shared Workbook, I would stay very, very clear of them. They have way too many limitations, and are far too prone to problems for my liking.

The situation you describe sounds, on the surface, like why databases were invented. This may not be the words you want to hear, but the "right direction" is to start looking at Access or another database platform.