I have a workbook full of several tabs. The main tab is the 'Report' tab, all other tabs are hidden. The information on the hidden tabs populate onto the 'Report' tab.
My question is, I have created a shape on the 'Report' tab to act as a button. This "buttton" is which I have hyper-linked with one of the hidden tabs. When the hyper-linked tab is showing, the button works fine. However, when I hide the hyper-linked tab, the button does not work. I would prefer to have just the 'Report' tab showing.
If Sheet1.Range("A34:A94") = "HIDE" Then For Each cell In Range("A27:A94") If UCase(cell.Value) = "HIDE" Then cell.EntireRow.Hidden = True End If End Sub
Problem: The code works fine if i manually change the $D$10. If I make changes to the Drop Down Box the cell link updates, but the rows are not hidden.
All I want to do is create a group of 3 option buttons in an excel worksheet for a user to select one of two farm programs or none. (CIG or MRP or None) When a user makes a selection either CIG or MRP or None appears in a designated cell. I even used code in the VB editor help but it only shows how to operate one button (which is absurd.) I found an example using 2 buttons, but that wouldn't work either. Found a tutorial using 3 buttons and that wouldn't work. Is this a conspiracy? Every time I try to find help to do something simple in excel lately I hit a brick wall.
1: Is their anyway I can get rid of the File, Edit, View, etc buttons at the top of the document so everyone that opens it can not see them? and also the save button, the idea is they have to use the button to save the sheet.
2: I have a button on the sheet with a macro that saves the sheet once it has been worked on, the sheet flashes when this button is clicked is there any way I can stop the sheet flashing ?
I want to unhide one row at a time but then also have an option to hide a row if it is not needed. I am using an ActiveX button to unhide one row at a time and that is working well, but what code would I need for (I assume) a second ActiveX button to hide one row at a time.
So i got a few macros on a worksheet and one of them is simply :
Sub Pr_Removefilter() ActiveSheet.ShowAllData End Sub
Ive worked on the excel a couple of times, everything fine. Then it started crashing upon saving (after changes made that had no possible connection to the macro, on another sheet). After a few painfull trials and errors i located the problem to be this macro button. I erased it, created a new one with the EXACT macro and it works. Why?..
i have an excel file that has several worksheet tabs most of which i have hyperlinks running on them, what i need to do is colate a couple of the sheets to a seperate excel file but when i try to copy them from the original file to the new file they will not copy because the info is hyperlinked!
I would like to send an image that has a hyperlink in an email, so when the user receives the email they can click the image and it will take them to a webpage.
I currently have one spread sheet. At the top of that spread sheet there is an object that hyperlinks to cell A180. When i click that hyperlink, it take me to cell 180, but it appears at the bottom of the spreadsheet, rather than bringing it all the way up to the top of my current viewable screen.
I have a table of many rows and columns of information, some of which is hyperlinked to seperate sheets in the same workbook, some are not hyperlinked at all. What I want to do is select a column and when a hyperlink is found going down the column, copy the sheet that it is linked to into a new book, then find the next hyperlink and copy that sheet into the same book as the first one. So if I have 25 hyperlinks in the column, I finish up with a new book containing 25 sheets in the order they were found. Hope someone can help me with this, it will save me hours of work.
If, say cell A1, contains text such as: "This Forum is wonderful, to see a great example for a post click here." <This is not an actual link here!> Is it possible to have the "click here" part as a hyperlink, and not the entire cell? Or- do i have to add an "image" or something similar to which i can add the hyperlink and then anchor the "image" to that cell?
Column C (starting at row 5) contains hyperlinks. I want to print the linked file, move down to the next cell, print that file, move on to the next, etc. FYI - The worksheets are from a seperate file.
I'm looking to make a simple button that would hide a given range of columns.
This is the simplest I could find:
VB: Sub button1() Columns("AD:AE").EntireColumn.Hidden = Not Columns("AD:AE").EntireColumn.Hidden End Sub
Although this works nicely, there was another way to do it (looks more ergonomic and doesn't take up spreadsheet space). Here's a screenshot of what I mean: ColumnHide.gif
I want to hide & unhide columns using only (plus minus) button which is appearing on top of current sheet. I have couple of files with that options built in, but I dont know how to do it. I tried to see macros but appears that there is no macros at all in that file??
I'm trying to get a Button to hide and unhide rows depending on Column A only which is a pasted link to other sheets. The rows should hide when Cell A is empty or 0.
or 2 buttons one for hiding and the other for unhiding rows.
I have a formatting macro that I recorded, nothing fancy just bringing in a few different spreasheets, and formatting them. I made this for someone who really doesn't know excel.
I linked this button to the macro and it works great, except at the bottom of the code I would like to put something that when this has run, it hides the button, so it can't be run again.
I need a little help here as I am trying something new, and am not sure how to proceed. I am trying to change from 2 columns to 3 columns where there are a few variables. This is the original:
I have a command button that is within a cell that when selected it insert a picture, the problem I have is when picture is in selected cell (same as command button) I can still view the command button from behind. I set the picture to “view from front” and Command button to “view from rear” but it doesn’t solve anything. I also have the command button checked to not print
trying to create a button to hide unsed rows, can anyone help? basically the sample below is what i want to do but it hides all the rows listed.. i want it to hide only unused rows in the rows selected if yes is selected and unhide them when no is selected...
wannahide = MsgBox("hide rows", vbYesNo) If wannahide = vbYes Then Rows("5:28").Hidden = True Else Rows("5:28").Hidden = False End If
I want to be able to have a set of buttons or a dropdown menu where i can put all the titles of my columns in.
After clicking on one of the titles the column must hide or show itself, is there a way to do this?
It's for an automated sheet wich contains a lot of information and this will be used by a lot of people, i want to make it easy for people to simply generate a sheet with just the info they need.
Using Excel 2007, I figured out how to insert a Toggle Button and program it to hide or unhide my columns F and G (which show cost data for products we sell) depending on the state of the button.
What I'd like to add to the button is text and functionality as follows:
- Columns F and G are shown, Toggle button IS NOT depressed and the button says "Hide Cost"
- Columns F and G are hidden, Toggle Button IS depressed and the button says "Show Cost"
I figured out how to change the text on the button, but can't figure out how to change it based on the button state. I know there has to be a way to do this.
How to hide command button based on another cell?’ [URL] .....
This works faultlessly but for only 1 Button. I tried adding in the code again for a second Button but it creates a conflict. I made a slight adjustment to your original code, to show the button when the cell is populated, which works well…
[Code] .....
Any way I can:-
1. Add additional buttons which reference their own cell?
