How to Protect my workbook (make it read only for users)

D

Dee

Hello, I've created an Excel workbook that is connected to SQL Server for
data. Sheet 1 has a pivot Chart, sheet 2 contains a detail report. I will be
putting copy on sharepoint site for users to access. workbook contains vba
code. Please provide suggestion on what I need to do to protect workbook
from modifications by users (user should only be able to view content). Also
please provide any performance suggestion. I don't want users to be able to
view code.
 

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

Shared Workbook Protection 1
Open Workbook to Protected/Read-only Warning 0
Attempted edit of protected cell jumps user to another cell 2
update links to password protected workbooks. 1
Change protection of a shared workbook (Excel 2000) 0
Refreshing Pivot Table on a protected spreadsheet tab 1
VBA code and protected cells 9
VBA Macro Training in Chennai 0

Top