i have a control button named "button 61" and a macro is assigned to it, within that macro there is a code : Worksheets("4_Lift Plan").OptionButtons("Button 61").Visible = False which esentially tells to make this same button invisible if certain condition is met and when i run it there is error...
I ran a Workbook Analysis on a spreadsheet using the Inquire tool (very useful).
It tells me one of my cells is invisible. Sure enough when I type into the cell the text is hidden.
I can simply Format Paint from another cell and then my text is visible.
But I would like to know how...
crossed post from here:
(i didnt get any proper answer).
I am looking for a way to save a copy of workbook, open it and delete some sheets...
I've been Goggling and can not find any find any info on how to make IE open a new tab next to an existing page in an invisible mode.
Is this possible?
I see code that can make IE open a new page in invisible mode.
Set objIE = New InternetExplorerMedium
So I'm not even sure what the best way to describe this is but...
I have a string value in Excel. In the excel sheet it reads as "4502575223". If I click at the end of this string and type backspace, the cursor will not move. If I press it again, it deletes the 3 off the end. It takes 2...
I made a new topic for this because the problem appears to me to be separate from the original problem.
See the original/reference post for additional details if needed.
I have a set of data.
I am using a COUNTIF function on a column.
Everything appeared to work fine. However, I ran a SUM...
I have a sheet where only a few cells can be altered. The sheet can be sorted and filtered by macro's. This works fine. But I do find the validation arrows confusing for the users. This part of the sheet is protected so they can't filter by the arrows (they need to use the macro's...
Hello Excel friends,
I have a command button located in a cell in column C. When hiding the entire column C, the command button is still visible. How can I make this command button invisible when the column is being hidden, using a macro?
This is my first time posting a question, because I've always been able to find pre-existing answers in the past - thank you! My issue is hard to describe but I'm sure the solution is maddeningly simple:
I have a spreadsheet with data in Column A, and a formula that references it in Column B...
I have a workbook (Excel 2010) with VBA & Macro buttons / charts.
It has 2 standard sheets - instructions sheet & sheet selection button menu to hidden template sheets. 22 hidden template sheets each have activeX buttons on them as well as at least 1 chart.
The problem I have is...
Is it possible to have an invisible but clickable area on a UserForm - I want to have a "back door" to take me out of a menu driven view, so that I can edit a spreadsheet. I'm using Excel 2010.
I have Excel 2003 and Windows Vista Home Premium.
I'm definitely not an excel pro! but I do know how to make basic formulas.
I'm creating a sheet so people in a weight loss group can enter their weight and inches, then each week can enter their new weight and inches and see, at a glance, how...
I have an excel spreadsheet (excel 2010) , There is a column in a sheet that when i type text , the text will be disappeared from the cell, cant see on formulas bar as well. But when I type number, i can see it like normal cell. I thing this column is set some formula to allow only number. Can...
I am running a macro that is causing my active cell indicator to disappear. In term of clicking around, I can still select cells, highlight cells and type formula's into cells. However, the black border that surrounds an active cell doesn't work. My file is completely macro driven and...
Hi there again!
I would like to ask if there is any way that I can make a conditional formatting formula changing my color font from being transparent. I made the font color of cells A1:A10 transparent by customizing the format with ;;;. But, if B2 has value, how can I bring back the font color...
I was just wondering is there was a way to Select a project name from a drop down list, then match its name up with the name of a table, and the table will appear on a worksheet.
How do I strip out all non-numeric characters?
I have 10,000 phone numbers, of which people entered in different formats, such as
212 123 1234
How do I strip out ALL the data/characters that are NOT numbers so the result is
I want all...