Locking the Update Feature

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have set up an order form which looks up various values
from other pages, as well as updates the date [TODAY()].
The people whom I send the form to only care about the
values as they are represented on that day. Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)? Is there an easier way then copying the
entire sheet and pasting special/ values only?

Thanks
 
That sounds like the easiest way to me.

I have set up an order form which looks up various values
from other pages, as well as updates the date [TODAY()].
The people whom I send the form to only care about the
values as they are represented on that day. Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)? Is there an easier way then copying the
entire sheet and pasting special/ values only?

Thanks
Click to expand...
 
Is there any
way to save a worksheet so that will not ask if you want
to update or to save the file (because of the date
function)?
Click to expand...

Do you mean saving the spreadsheet as read-only? In that case the users
wouldn't be able to save changes to it.
 
Back
Top