Hi all,
Hopefully someone has come across this problem and knows the reason for it.
Some background on the file:
This file of course has a tedious 10+ years of history (maybe more) and at the moment it contains 3063 sheets. Over the years it's been broken down into pieces to keep the number of...
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...
Hi folks,
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...
I have a text box that has default text that disappears when you type in the box. What vba code would make the box invisible when printing if it contains the text "Please type notes here"?
I created several PowerQuery but I want to hide it.
Now, everyone clicking Data > Query and connection can find it.
How to make it "invisible" to others ?
Thanks
Hi,
crossed post from here:
https://www.excelforum.com/excel-programming-vba-macros/1247106-the-fastest-way-to-saved-workbook-copy-and-open-it-as-invisible.html#post4983976
(i didnt get any proper answer).
I am looking for a way to save a copy of workbook, open it and delete some sheets...
Hello,
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
With objIE
.Visible =...
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...
Hi,
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?
Kind regards
Ingemar
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...
Hi there
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.
Thanks,
OldMan1950
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...
Hi There,
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...
Hi,
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.
Eg;
<tbody>
<tbody>
<tbody>
Project Number
Project Name
C2269
Spring Farm
</tbody>
</tbody>...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.