Thread: Lock and password protect only cells with formulas on all sheets in a workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Lock and password protect only cells with formulas on all sheets i
Hi Steve

assignment of a unique password

Do you want to use a different password for all 50 sheets
Do I understand you correct

--
Regards Ron de Bruin
http://www.rondebruin.nl



"steve" wrote in message ...
Thanks for your feedback Tom.

I have tried to record a macro to perform all the steps but the macro
is not able to record the assignment of a unique password to the
sheet. It will only lock the cells.

Any other suggestions?
Are you aware of any VB code that could do the trick?

Cheers,

Steve

On Sat, 8 Jul 2006 16:37:01 -0700, Tom Ogilvy
wrote:

No. You must protect each sheet individually, but you can do it in a macro.


Reply With QuoteReply With Quote