LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BLW
 
Posts: n/a
Default locking information

I am working on a project where a user will be using sheet1 that uses
information on sheet2. Is there anyway for me to make it where the user
cannot accidentaly delete or tamper with the information in sheet2. Also, I
am will be using the Vlookup function on some of the cells in sheet1; is
there anyway for me to lock in that equation in that cell at all times, so
that if the user decides they mess up and they delete the text in that cell,
it doesn't delete the equation??
 
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
Aggregating categorized information from several worksheets Pedro Fonseca Excel Worksheet Functions 1 May 13th 05 07:06 AM
Update a spreadsheet with new information. a6kim Excel Discussion (Misc queries) 1 May 2nd 05 11:56 AM
Clearing information in certain columns jolly_lolly Excel Discussion (Misc queries) 1 April 22nd 05 02:41 AM
Sharing information between Access and Excel C.M. Warden Excel Discussion (Misc queries) 1 March 16th 05 12:38 PM
Duplicating Cell Information [email protected] Excel Worksheet Functions 1 March 10th 05 12:47 PM


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