Recent content by Kiran Kumar

Guys, I have got the answer for my self. Sorry for troubling. Pls ignore the post Rgds, KK

Hi Everyone! I prepared a userform through excel and stuck to action an option. I have an excelsheet, "List" with details from A1 to B10(row data keeps extends) and I have created a userform and linked the data source as per the list and now the list displays with all the information in 3...

Hi there, I have written a macro and assigned to a button on the excel. Once I clik on the button, the current excelworkbook goes as an email. Now, the challenge is with the size of the file. As its a huge file, is there any way that once I click on the button it automatically zip the file...

Hi there, I have created a form on a excel spreadsheet and need your assistance in finishing it. I have inserted a checkbox with caption as Financial ledger balances for corporate. Now I want the ledger balance be displayed in blue and underline and the rest be in black in color. I tried...

Hi Sreekhosh, I dont think you can protect the macros permanently as there are lot of softwares available in the market to crack the passwords. Regards, KK

Hi there, I have done online VBA course with Chandoo.org and it was quite good. It would be great if you could mail to chandoo about your concern instead posting like this. Chandoo is a master for all of us and it doesn't feel good if someone tells like this. Regards, KK

Hi Debraj, Tat was fantastic trick. thanks everyone for your support! Regards, KK

Hi All, I just found that there is no direct option to clear all hyperlinks at once! The only option is macros. Thanks for all of your efforts in trying to get the answer. Regards, KK

No worries. Pleasure to get to know various excel scenarious. Regards, KK

Nope, doesn't work. Only the link highlight color(blue) has gone and not the hyperlink. Any solution please!? Regards, KK

Hi Bobhc, I cant see remove hyper links option when I select all cells. It appears only when I right click on single cell. Appreciate for any answer to it! Regards, KK

Hi Gopikrishna, Here is the macro to it. Suppose you have spreadsheets like Kiran, Rohith.... example: Login details for Kiran sheet is: Username : Kiran Password: kiran123 ''''Macro Sub User_Password() x = InputBox("Enter User Name") y = InputBox("Enter Password") If x =...

Hi, Could you please elaborate it and it would be very useful if you upload a sample data sheet so that we can try to answer it easily. Regards, KK

Hi Folks, I appreciate you have a better answer only through excel and not through macros. I can select each cell and remove but that is very manual. Need to remove all the hyperlinks at once. Please note that the cells addresses keep changing for me. Regards, KK

hey! I got the answer. ha ha:-) Here it is!! Sub Hyperlink_remove() Sheets("Test1").Hyperlinks.Delete End Sub