LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Select the worksheet, do formatcellsprotection and uncehck locked, then
select the cells you want to protect (for formulas do F5special and
formulas), then repeat and check locked, finally protect the sheet


Regards,

Peo Sjoblom

"Gail" wrote in message
...
I have a large worksheet with different formulas in different columns which
I
want to protect from change but I want to allow others to enter data into
the
worksheet.



 
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



All times are GMT +1. The time now is 07:31 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"