hi
Select all the cells in the workbook.
Go to Format - Cells - Protection
and uncheck the locked button
Now you can select the cells which you want to be locked for editing
when you protect the sheet ,
go to Format - Cells - Protection
check the lock button
Protect the sheet , only those ran
Hi Pat,
You can create a macro which would copy the data from the current
excel file to another excel file which would act as a database for all
responses. if you can send the questionnaire that you have prepared, i
can try this for you.
Nishant
--~--~-~--~~~---~--~--
Hi friends,
i am posting here first time my views.
if you want to copy the cloumn A and C
then first u hide the cloumn B with key CTRL+0
then u select the cloumn A and C
then press ALT+ ;
and you copy the data
and paste only cloumn A and C
Tks & Rgds
Jituji Bombay
--~--~-~--~~-
What do you want the macro to do exactly
On Jun 20, 1:08 pm, janet dickson wrote:
> hello guys i need on help on making a macro for getting color values/RGB
> values for cells or color boxes. See my attachment with color i want to have
> RGB
>
> Hugs
>
> Legends.xls
> 49KViewDownload
--~--~
Hi Ankur,
I am not sure whether i have understood your query correctly or not.What i
understand is, if party name and bill no are same, then the corresponding
amount is extracted in sheet 2.
Based on that, i believe following is the code that you are looking for:
ActiveCell.FormulaR1C1 =
"=IF(VL
Name: Upendra Singh
Tip: color Every Alternate Row in data with conditional Formatting (without
Macro)
1. Select the data you want to Format.
2. Go to Conditional Formatting.
3. In the first box, Select “Formula is” and type the formula :
=MOD(ROW()-1,1*2)+1>1.
4. Set
Hi Ankur,
Do As Below :
1. In Both the Sheets, Insert one column.
2. In The column inserted, enter a formula : =PartyName & BillNo. (where
Partyname is the cell for PartyName and BillNo. Is the cell for Bill No.)
3. Based on above inserted column, do the vlookup and you've done.
Mer
Hi Vinay,
Please find enclosed sample xl Sheet. Please note that in the cell A1, I’ve
written my name but that is visible only in formula bar, not in Excel Sheet.
I Hope it helps….
Regards,
Upendra Singh
9910227325
---
HI Ramesh,
Please find the attached sheet with the solution.
Following is the way to protect a cell.
Select a cell and then choose: Data | Validation | Settings. Change the
'Allow:' drop down box to 'Custom' and then type ="" in the formula box.
However it will allow user to delete the content
Send a sample file..
On Jun 20, 2:12 am, Asad Nedariya wrote:
> Hi all,
>
> I joined this group recently in order to get some help on Macro. I do
> not know much about macros but I am trying to learn and hence any help
> would be appreciated. Here is my problem description,
>
> 1. There is a fol
Not sure what you question is exactly about... but
If you want a macro to open automatically, each time a user opens a
file
1. , then save the macro in "Personal Workbook". This is a default
workbook which is always hidden.
2. create an add-in
or
if you don't want a macro to open each time automa
Try the codes below
Public FileCounter As Long
Public FileNameArray
Public NewWorkbook As String
Public Sht As Worksheet
Sub main()
Dim i As Long
NewSheet
GetFileNames
For i = 1 To FileCounter
Workbooks.Open Filename:=FileNameArray(i)
NewWorkbook = ActiveWorkbook.Name
That worked out great actually.I just have to either 1 manually change
the code when I need to change the value I'm looking for perhaps I
should look at having a user input box come up :)
Thank you Paul, a great help and huge time saver (and looks very
easy!)
On Jun 19, 9:29 am, Paul Schreiner
Hi,I am looking to design a questionnaire via Excel with Yes/No options
against the questions but also would like to have one or two text boxes so I
can get general feedback from the recipients.
Is it then possible instead of the recipients emailing me back the workbook
that they can submit (autom
hello guys i need on help on making a macro for getting color values/RGB
values for cells or color boxes. See my attachment with color i want to have
RGB
Hugs
--~--~-~--~~~---~--~~
---
Dear Members
i have one problem
in one sheet there is data as
party name bill no. amount
there are 100s of party detail,one party may has many bill no
in another sheet
party name bill no. amoun
Dear Abdul Raheed,
Can u change the addin to western format ie.
lakhs to hundred thousand and crore to ten hundred thousand
Ajay
On Fri, Jun 19, 2009 at 11:08 AM, shafiq online
wrote:
>
> Dear Abdul Raheed,
>
> I am an old member of excel-macro, I have experience of using excel. I want
> to l
Dear members,
How to protect range of cells in worksheet. I attached a workbook in
that red colored cells should not allow others to edit.
Please find the attached workbook.
Thanks&Regards
Ramesh
--~--~-~--~~~---~--~~
---
Name: Bakul Patel
Tip: Use F8 key to select range of cells.(No use of shfit key/mouse to
select range of cells)
If you want to DEFINE name of different cell ranges, do like this.
Example:
I want to give different names to following ranges using DEFINE function.
Range:A1:B20, A1:X10, A1:S30,
19 matches
Mail list logo