Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel on a web page

Status
Not open for further replies.

pabby

IS-IT--Management
Jan 5, 2004
47
GB
HI,

I am looking to see if a particular spreadsheet of ours can be put on a web page/site. The idea is that this spreadsheet would have multiple pages with info for different contractors per worksheet. they would need to log in to their own page individually and should not be able to see another contractors info.


Is there an out of the box product for this type of thing - I have never tried this before so I have little knowledge about it.

Any help would be appreciated.

thanks,

Paul
 


Paul,

This would take some VBA Programming.

Each contractor would need a unique id.

You would programatically SAVE the workbook in such a state (all sheets VERY HIDDEN except a Splash Sheet) so that it could only be viewed...

1) if macros were enabled and
2) a valid id were entered.

The valid id then makes the appropriate sheet(s) VISIBLE.

When the user CLOSES or SAVES the workbook, the code restores the original state.

Skip,
[sub]
[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top