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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change workbook from Read Only to Write

Status
Not open for further replies.

advox1

Technical User
Nov 28, 2003
26
0
0
GB
Hi

I have a workbook which is in a public domain for people to view as Read Only (no passwords involved). I need the same people to Write information to the workbook via an input form.

I have designed a button which will open the workbook and display the inputform, but need to know the code for how to change the workbook to Write for the period of time that the data is being input via the form and then change it back to Read Only once the input has finished.

Can anyone help?

Thanks

Joanne
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top