sensitive

I have about 90 worksheets in my workbook. About 75 contain sensitive financial information that I don't want available when someone is sent the file. Is there a way to "group" the 75 sensitive worksheets so that with one click of a Macro button, all 75 worksheets are hidden with a password...

I need somehow to search column B for the word Budget. If the word budget is found, display a prompt that has an OK button, and once selected, macro continues. Just looking at formulas, before creating code, I tried: =SUM(COUNTIF(B:B,"Budget")) Cells in column B might have a value such as...

Hi I can write msgbox with ( ) or without like the code below? Why I can do that? This function is not returning any value then I thought it should not take ( ), Also I noticed that, I defined X as Int. Then whenever I type x as small letter, excel change it to big X. Does that mean variable...

Good afternoon Guys, I'm really bad at vba. And I'm trying to understand the best way to do this procedure. Maybe you can help me. I have a Workflow and every line has a LegId. This id is Case Sensitive (since there are equals IDs and the case sensitive is the only difference. This LegId is on...

Hi all! I hope to have chosen the right section of the forum, if not, I'm sorry, feel free to move my thread in the most appropriate one. I'm writing since I have some difficulties in writing the correct SQL instructions when using Microsoft Query to pull out data from an Excel table. I'm...

I have this macro I use a lot and I need help changing it. The macro removes case sensitive duplicate values from column A, opposed to Excel's remove duplicates feature that ignores case sensitivity. Can someone show me how to change this code so that instead of removing case sensitive...

Hello!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Can somebody help me out with some VBA solution for my below problem:<o:p></o:p> -I have two columns<o:p></o:p> -In column »A« are listed values in black and red font color<o:p></o:p> -I...

Hi Everyone, I'm developing a tool for analysing educational data which involves the input and the analysis in one workbook. I am controlling the input with data validation using a named range because of the amount of times I would have to repeat the same delimited list when I create the other...

hi guys, here's my current code: Private Sub Search_Click() Dim datatoFind Dim sheetCount As Integer Dim counter As Integer Dim currentSheet As Integer On Error Resume Next currentSheet = ActiveWorkbook.Index datatoFind = InputBox() If datatoFind = "" Then Exit Sub sheetCount =...