Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

how can i protect a document so nobody can delete it

This question relates to any microsoft documentsand the document i want
protecting is Excel.

how can i protect it so nobody can delete the document. (the document
itself rather than parts of the document)


Post your answer or comment

comments powered by Disqus
Does anyone as an idea how can I protected a excel file to specific computer, so that it can’t be opened or used in any other PC??

This without using any other excel file.

Thanks

How can I export a document from Excel to yahoo senders

I have been given a spreadsheet for work that helps me keep track of time of employees on projects.

I've listed the projects in the rows and matched them with each team in the columns.

All of the data is derived from another tab. Sometimes none of the teams work on a particular project during the month, therefore the value is displayed at 0.00. How can I format the tab so that the rows that have a value of 0.00 are either hidden or deleted?

I really want to kno How can i protect a workbook from being changed and saved as a copy without a box poping up in the first place saying 'insert password'. So basically like the protect sheet....i tried the protect workbook but it just wouldnt work, i dont know where im going wrong.
Please help this is urgent =(
Bonbon

I'm working an an attendance sheet, so for instance I have this:

Vacation Personal Sick 1/1/06 1/2/06 1/3/06 1/4/06 1/7/06 1/8/06
0 0 0 S V
P

How can I create a formula so the when I type in S for sick day it'll equal
1 under the sick days column, etc.

I have a workbook with 31 sheets in it. How can I protect/unprotect all 31 at once? It takes too long to do them one at a time and they will all have the same password anyway. Thank You.

Hi ,

How can I catch a Paste action behaviour(Paste menu click and ^v) and default it to PasteSpecial-Values.

I should be able to catch these events and call my custom subroutine to handle the situations.

thanks
Vasu

I created a worksheet with several projects. Each project has a hyperlink
back to project documentation on a network pass protected drive. I emailed
the spreadsheet to various people within the company, only to find out that
the hyperlinks do not work. A message appears and says "Cannot open specified
file".

How can I create the hyperlink so it does work?

Thank you

How can I perform a "Save As" and change the name of a protected excel
spreadsheet? I know it can be done in word but what about excel?

How can I perform a "Save As" and change the name of a protected excel
spreadsheet? I know it can be done in word but what about excel?

Hello
I started a validation of an excel sheets, have some questions:
1. how can I force a user to fill a certain cell - say to introduce his name of some form number before he wants to print or before he wants to save? I would not like to use VBA but rather a simple "if" and so on conditions. Could you help with anything particular?

2. Can I leave only a small part of a sheet existing making disappear all the rest? Lets say I need to validate a sheet and I decided to check during the validation every cell in it (not the risk managment approach), can I leave only a part of it an an excell sheet (like a word documents - which contains 1 or 5 or 20 pages - a final number of cells, let's say a rectangle A-G, 1-30

Hi,

I have several excel files protected with the same password (ex: pwd) in a directory. I want to create a macro that is going to open each file and copy the inside information to a new workbook.

In VBA, how can I open a excel file protected?

Regards,
Élio

Hi,

How can i protect cell data against modifications in excel sheet? as i would like to prepare a template which can not be modify by other user. Please let me know the solution ASAP so that it would be a great help.

Thanks,
Prasad

Hi!! How can i prevent a user to open a book in the active application... does anybody has a code for that.... is that possible???

Im trying that so that the user dont get mad, when he realize he doesnt have some commandbars activated.....

Thank u for your repplies....

Hello,

How can I copy a formula but only every 65 cells.

For exmaple, I want the formula in A66, A110, and so on but not in A65 or A67.

The problem is that I have a table full of information and I need to extract identification characters from it. They appear every 65 cells at the exact same location.

Please let me know if I explained it decently.

V.

How can I generate a list by name of the worksheets in a large workbook? I
have a workbook that contains over 100 large spreadsheets. Each worksheet
contains detailed information on a specific property. I have been trying to
figure out how to generate a list of the worksheets so that I can show which
properties are captured in this workbook. I do not want to go to Access. I
do not have time to design a database that gives me the information that I
can access now in seconds using a summary sheet. The list I need is for
management reports.
Thanks, Connie

I would like to link one long row of cells from one worksheet to one long
column of cells on another. I have to do this in many cases, so paste-linking
one cell at a time is not feasible. How can I transpose a paste-link
operation?

How can I continue a series of Text and Number values if the cells are not
adjacent? The values would be something like: Text 1, Text 2 etc. I need
to be able to change the cell containing Text 1 to Text 12 for example and
have all the other cells fill in sequentially, so that I would have Text 12,
Text 13 etc.

I have 2 questions. I have a formula in a cell and want to copy it to an
adjacent cell without the formula changing based on the cell location. Ex:
In A1 I have the formula =M1+T1, when I copy this to B1 it changes the
formula to N1+U1, if I copy it to A2 it changes it to M2+T2. How can I copy
the cell without changing the formula ?
My second question is I have a cell with the formula =D1. When I drag or cut
another cell into D1 it changes the formula to =#REF!. Is there a way to
maintain the original formula of =D1 ?

How can I insert a vertical column break between data to create a new column?
I pasted data that has a combination of words and numbers. I want to separate
the numbers from the words so I can rank the numerical part of the data. Is
this possible?

I would like to know if there is a way to protect or lock a worksheet, inside
a workbook, so that other users cannot even open the worksheet. I am
familiar with how to password protect a worksheet so users cannot edit or
modify locked cells, however, I would like to keep other users from even
going into the other worksheets within the workbook. I have not yet found a
method for doing so.

Or is there a way to "hide" a worksheet within the workbook so that other
users cannot see it?

I have a price list of items on Sheet2 with product codes from 0 to
999 in column A and prices in the adjoining column B. I have called
this price list "items".

Now, when I try to do a vlookup function on a cell within Sheet1, I
come up with a price regardless of whether that cell is blank or has a
zero in it. My function looks like this: =VLOOKUP(Sheet1!A1,items,2)

How can I stop excel interpreting blank cells as cells with zeros in
them? Or how can I alter the function so that it doesn't try to match
up a blank cell A1 with a Cell containing 0 in table "items"?

I appreciate your help in advance.

Matthew Dowling

I would like to know if there is a way to protect or lock a worksheet, inside
a workbook, so that other users cannot even open the worksheet. I am
familiar with how to password protect a worksheet so users cannot edit or
modify locked cells, however, I would like to keep other users from even
going into the other worksheets within the workbook. I have not yet found a
method for doing so.

Or is there a way to "hide" a worksheet within the workbook so that other
users cannot see it?

Hi All,
How can I set a column as text so if I sent 0001 to a cell it is 0001 and not 1 as it is doing
now. I followed the other thread but I need the answer for C#.

Thank You.


No luck finding an answer? You could always try Google.