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 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
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 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
I suggest to join any online or live VBA training instead jst reading books. I have joined VBA in chandoo.org and it was quite useful for the beginners.
Regards,
KK
Hi there,
Good Morning!
I have an excel form where we usually fill the form and save as the file in our local share drive with a name as per B5 cell.
Is there any way that once user enters a name on B5 cells the form should automatically save as onto the sharedrive with B5 cell data as the...
Hi there,
I know it is silly, but I actually stuck in getting the solution.
I have a share point dowloaded data in A to H columns. My G and H columns shows me the dates like below:
G Column:
08/21/2012 08:20:25 AM
08/20/2012 02:20:10 PM
H Column
08/21/2012
08/20/2012
Now, I want G...
Hi Vijay,
Happy to see you again!
You can change the sheet names at any time, but ensure you do not have a sheet name with "Consolidated" & "OneTimeValue". As these two sheets will be used by the macros for you to get the output.
If you wish, you can draft me a test mail to...
Hi bobhc,
Hope you have the first name in G column, middle name in H column and Last name in I Column and you do the concatenation in J column.
With the help of 3 additional columns, I can get you the anwer.
Suppose your data is like below:
G1 = Test
H1 =
I1 = 2
J1 = Concatenate(G1...
Hi Vijay,
Welcome to the forum.
Here is the code to extract unique text from all the sheets ("A" Column)
Change the column names as your requirement.
You can do further followup for any queries. Am going for a movie now. Will come back and see the loop of queries and learn something...