LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelly
 
Posts: n/a
Default How do I protect multiple sheets at one time?

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time sheets Driver Excel Worksheet Functions 5 November 7th 05 11:19 AM
how do i protect multiple worksheets Dennis Excel Discussion (Misc queries) 2 October 31st 05 11:41 PM
How do i auto create multiple files from 1 with multiple sheets Kathy Excel Worksheet Functions 0 July 26th 05 01:23 AM
How do I protect formula cells on multiple sheets? Webdiva Excel Worksheet Functions 0 May 3rd 05 08:29 PM
Time Sheets Helen Black Excel Worksheet Functions 1 March 19th 05 01:41 PM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"