Can I set up a worksheet as read only for one user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that I want some user to be able to access and change data
and other users to be able to access but can't change any information. Can
that be done using read only? If so, how?
 
Hi
in the 'File - saveas' dialog under the 'Tools' menu you can specify
this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To protect user's privacy 1
Identifying a Read Only status 2
Allow text in locked cells on a worksheet from a userform 16
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Need warning message before a user changes worksheet 5
Macro to open a workbook as read only 2
No Prompt for Read Only 13
Code based on opening Read Only or not 4

Back
Top