sheet selection

Hello there! I'm working on an Excel table, which has multiple worksheets, and I always have to print only some of them. I wrote a simple cell reference to determine which sheets I have to print (atm. its value is: "EX_A1", "EX_B1"). I wrote a VBA macro which should handle the sheet selection...

I have a selection box that is populated with a range that is populated with the names of all of my sheets. The selection box is linked the the range C3 noted in the code below. I want to be able to click the button that will run this sub and have it activate the sheet selected from the...

Hi, I got an workbook I want to save as pdf. I want the pdf to contain multiple sheets, and that can be done by selecting each sheet and then save it as pdf. The problem is that I don't know which sheet to included. That is because I want to see if it is contents in cell A7, and if so: include...

Hi All My workbook has sheets named from A to Z and a Master-sheet with values auto-populated from sheets A-Z. A dynamic list on Mastersheet updates itself based on which sheets have values greater than Zero. That dynamic list only has the letters A,B,C - Z (excludes tabs which have total value...

Hi all, I'm trying to create a report in a excel worksheet that will gather information from several sheets (in theory will end up with circa 1500 different ones) The sheets are automatically created in groups of 3 and the name of each sheet will be something like "Project", "Project CX3" and...

Heya all, As the title says this might not be as simple as it seems (Or at least it is too tough for me with my whole 1 and a bit months of using VBA >.>) They Simple part: I need a message box to appear whenever you try and leave a sheet and the Cell "AC1" says "Incomplete". It's okay for...

I have a controls worksheet with a lot of functions tied to it and I don't want anyone changing anything, plus I need the real estate. I know this is the code to go to full screen: Application.DisplayFullScreen = True Are there Sheet_Select and Sheet_Unselect functions? Is there a way...

I'm really rusty on my VBA and this is really simple, but I can't seem to get it to work. I'm trying to create a database in excel. Basically I have a data entry form and one part allows you 4 options. The sheet that the data is entered in depends on which option you choose. So if you choose the...

basically, I have a main data dump sheet named ContestReport. I'd like to create sheets based on Culumn B (minus the header) and then copy the row to the appropriate sheet based on the value of B. This is correctly creating the sheets, but I'm running into an error with the copying and I am...

Hello, I am wanting to link to a seperate workbook cell using the formulae ='[INF_Cap_8400-8051.xls]Infra Cap'!$C45 BUT instead of using the workbook to link to the cells of interest I would like to use text in Cell B1 for example. <TABLE style="WIDTH: 127pt; BORDER-COLLAPSE: collapse"...

Hi all I have created a script which attempts to grab data from a master worksheet and then select and manipulate 'like' worksheets (at the moment I've just put at msgbox as a place holder). The thing is I'm having a problem with resizing the array. As a result the first sheets are selected...

Hi, I am trying to write a macro to start at the sheet on the left hand side of the workbook and perfrom some actions until the right hand sheet is reached. I just don't know how tell the macro to stop looping once the action has been performed on the right hand sheet, and was wondering if...

Hi guys, I have read many threads about members trying to navigate their way around workbook sheets by using a Combobox. There seems to be many alternatives but not a simple solution, can anybody help please? My problem is this: I have 10 sheets (Sheet1 to Sheet10) I would like to have a...