debauch
02-22-2007, 08:30 AM
Hi there.
There is a list we use at work of 2000 or so users, and it is consistantly incorrect. I am working to create an interface to dummy-proof the process. All the excel sheets are hidden in the background and not accessible, unless you have admin rights to my app.
My question is, how can I create a copy of one of the tabs, and save it as read-only or password protected. What I want to do is: once they have made all the updates in the interface, save the one sheet so they cannot make any updates manually once they are ready to post the list. The below I was using to create a copy, but it leaves the opportunity to change data.
Sheets("BigList").Copy
Thoughts?
There is a list we use at work of 2000 or so users, and it is consistantly incorrect. I am working to create an interface to dummy-proof the process. All the excel sheets are hidden in the background and not accessible, unless you have admin rights to my app.
My question is, how can I create a copy of one of the tabs, and save it as read-only or password protected. What I want to do is: once they have made all the updates in the interface, save the one sheet so they cannot make any updates manually once they are ready to post the list. The below I was using to create a copy, but it leaves the opportunity to change data.
Sheets("BigList").Copy
Thoughts?