How do I protect multiple sheets at one time?

G

Guest

I have a workbook which has many users. There are over 20 worksheets in
which I have formulas which need to be locked. The only way I can find to
protect the formulas is to protect each sheet individually, which is very
time consuming and a nightmare for editing/updates. Protecting the workbook
does not work because I only want certain cells locked, not all of them...Am
I missing an easier way? Thanks!
 
V

VETcalc

There is a FREE Plug-in for Excel called ASAP. This is a fantasti
program that
performs many additional and enhance task.

Using this program, you would select Sheets from the Menu and then
select Protect All Sheets.

You can get further info at: http://www.asap-utilities.com/

Regards,

Bo
 

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

Multi worksheet protection & editing ability 6
Macro to protect multiple sheets? 12
Protecting Multiple Worksheets at the same time 1
Protect Workbook 4
Protecting Sheets 3
protect / unprotect multiple sheets 4
Can I protect a range of worksheets in a book with one action? 2
Moving between sheets in Excel w/o keyboard 1

Top