select sheets

Hello All, I got 5 sheets with different tabcolors. The tab of a sheet becomes red when a certain value on the sheet isn't met. When it is, it becomes green. The only sheets I want to select as an array are the green sheets. How can I do this? For example: Sheet 1 tab color = Green Sheet 2 tab...

This is a bit beyond my reach. I'm needing to write some vba that I can assign to a macro button which will select the names of those sheets determined by a marker "X" running from a front page summary sheet which is basically as follows: Tab Name (Col A7:Z Last row) is where the sheet names...

Hi, I have a macro that will select multiple sheets at one point. I'm trying to think of a way to recall that selection later on, possibly by naming it when it's first selected. I thought something like this would work, but no dice: SheetstoPrint = Sheets(ActiveWindow.SelectedSheets) ...

Hello, I hope some Darling can assist me. I have a macro that selects all sheets - no matter how they are named - or how many sheets there are (normally 5 to 10 new sheets). The problem is that there are sheet names in my macro and I might have one new sheet or two with different names from...

I have put together a Userform for entering data into a series of identical spreadsheets in the same workbook. The form contains a combo box that switches the active worksheet by selecting the sheet's number. However, once the new sheet is selected, the Userform continues to edit the cells in...