Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default how do I lock formulas, but still allow rows to be added or delet.

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row height.
Any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default how do I lock formulas, but still allow rows to be added or delet.

Tools Protection Protect Sheet
Then, choose what you want the user to do or not do.


Regards,
Ryan--


--
RyGuy


"ericaamousseau" wrote:

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row height.
Any suggestions?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default how do I lock formulas, but still allow rows to be added or delet.

I think this requires XL 2003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ryguy7272" wrote in message
...
Tools Protection Protect Sheet
Then, choose what you want the user to do or not do.


Regards,
Ryan--


--
RyGuy


"ericaamousseau" wrote:

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row
height.
Any suggestions?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default how do I lock formulas, but still allow rows to be added or delet.

xl2002, actually.

Bernard Liengme wrote:

I think this requires XL 2003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ryguy7272" wrote in message
...
Tools Protection Protect Sheet
Then, choose what you want the user to do or not do.


Regards,
Ryan--


--
RyGuy


"ericaamousseau" wrote:

I can't find my previous question. I want to lock just the formulas. I
still want to be able to add or delete rows and be able to adjust row
height.
Any suggestions?


--

Dave Peterson
Reply
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
Preserving hyperlinks when rows are added Jimbob Excel Discussion (Misc queries) 6 August 5th 09 03:13 PM
lock column size for some rows and resize for other rows. Gorskim Excel Discussion (Misc queries) 1 November 21st 07 12:12 AM
Identify New Added Rows AnneMarie Excel Worksheet Functions 2 July 10th 07 04:20 PM
Rows added after refresh not in formula Greg Snidow Excel Worksheet Functions 11 November 21st 06 09:32 PM
Excel cell show sum upto 500 Exceede delet without if else conditi Yasir U sman Excel Worksheet Functions 2 November 25th 05 04:02 PM


All times are GMT +1. The time now is 05:41 PM.

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

About Us

"It's about Microsoft Excel"