Search:

Thank you so much JBeaucaire.
One more help -
The data is captured correctly. However, it allows duplicate entry of data.

country model chassis no
Kenya 10.75 1111
Sudan 10.85 2222...

Hello,
I have a sheet (sheet1) which is used by different users many times to create some documents.
After creating the document, the data entered is deleted and new data is entered.
I want to...

Hello,

I am trying to get a popup calendar in some particular cells when selected.

Can anybody help in this?

Thanks in advance

I am trying to create a form normal excel sheet and want to provide a guide to the participant on what information to put in the cells. I want t a faint text in the cells as an instruction which will...

Is it possible to install 2 different USB modems in one PC (win 7)?

After installing first modem, I cannot see the set up file for the second modem when connected. It tries to open with the first...

The first file attached was locked for seeing vba codes, revised file attached, please refer that.

Sorry for the inconvenience.


Thanks

Thanks JBeaucaire.

I have attached the sample file which already has some codes, can you look into and help me?

Thanks

Hello,

I have a working workbook with many linked sheets and formulas.

I want to export one sheet out of this (named "1") and save in new workbook without formula (i.e. save as value) and the...

Thank you JBeaucaire !

I wish to lock the cells in a particular sheet ("CMstr", see attachment) in which user has entered data and balance cells to be remained unlocked.

The cells should get locked when the user saves...

Hello Perito,

Any comments on this please?

Thanks

Thank you Perito.

I tried to add some more data in the sheet and check. I am getting error. Can you look into please?

I am attaching the sheet for your reference.

Thanks

I have large data running into many rows and new data is added regulary. As it is updated regulary, it is not possible to sort it every time.

I am using a normal LIST validation for getting drop...

Great!

Thanks JB

I am attaching original .xls file which I am using. I am unable to attach the converted .exe file.

Below is the link of the program I have used to convert .xls to .exe -

Converter from XL to...

I am using below macro in a sheet and wants to convert the sheet to .exe format by using a XLTOEXE program.

Macro works perfectly in normal .xls sheet. However, it does not work correctly in the...

Thank you !

Is there any way to disable only "Save As" option (Save option works)?

Thanks

I have started getting an error while accessing the Security option in Macro. I have attached a captured shot on this for reference. I am unable to change the security level for the excel.
...

Thank you for your reply.
I was able to catch the error - it was in the assigning of name.
Now it is working all right.

I have a sheet linked to a cell containing SUMPRODUCT formula (like "=SUMPRODUCT(--(dealer_List=A6),(claims_recd),--(Data_List>=$B$2),--(Data_List<=$D$2))".

"claims_recd" is NAME i have given to a...

Thank you for your prompt reply. I will try with combo box.

I have to put the zoom size of me worksheet to 75% to see the complete page.
With this, the font size on the various drop down menus gets smaller.
Is there any way to increase the font size...

Thank you JBeaucaire !

I have a data as below (see attached sample) where I want to apply a formula (something like vlookup) which will give me the cell value based on the row and model code (A,B or C).

If I put labour...

Thank you for your reply.

Honestly I am not in wrangling. My be I did not express exactly what I am looking for.

I am attaching the same file which you have edited. I have just added protection...

It is normal protection available in excel (Tools/ Protection) and not by any macro.

Since I intend to circulate these sheets to various people, I am thinking to protect the workbook just to...

Thanks a lot JBeaucaire for your help!

Now it's working fine. One last question, the file is working fine with 'unprotected' workbook. However, when I lock the workbook, I am getting an error.
...

Hello JBeaucaire,

Can you please go through the sheet sent earlier and check the error I am getting?

Thanks in advance.

Sorry, forgot to attach file.

Thanks a lot for your reply.

I tried to put the combined code but still getting some error. I am attaching the file for your reference.

I would appriciate if you can go thourgh the code and...

Hello Friends,

I have added another code as below with aove code. But getting an error of conflict.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim myWS As...

Hello JBeaucaire!

Issue resolved, I had earlier kept the code in different sheet. I am sorry for that.

Now it is working fine.

Thank you very much for your help.

I have attached a Test Sheet for your reference and eagerly wait for your comments.

I sincerely appreciate your help.

Thank you so much.

Hello,

Thank you so much for your reply.

However, this code is showing below error -

Runtime error '1004'
Method 'Visible' of object'_worksheet' failed

Can you look at this please?

Hello,

I am working on VB code in Excel 2003 for getting below result -

(1) After opening the file, it will always go to "First worksheet". This will have a message informing user that macros...