I have an excel spreadsheet I have created as a printable form. It all fits nicely onto one page. I would like to be able to email it to people and have it look like a one-page form. It looks great in Page Layout view, but the only problem is that there are a bunch of extra sheets that show up as well. Is there any way to remove/hide these extra sheets that are not needed? Or is there another way to send this out so that it comes to folks as a one-page form so that they can alter the data in the cells but not the page formatting?
I'm making a sign in and sign out sheet for work and when I go to view and then page layout I get not only that but other sheets without the texts. Also, when I go back to my normal view I see dotted lines that show the page size over and over again. Any idea how I can see only what I want to see on page layout and get rid of those dotted lines?
I may be a bit thick here but i am trying to change between portrait and lanscape on the same worksheet on printing. I have a very good diary planning spreadsheet set up and I am keeping all the supporting evidence in the same workbook but on different worksheets. Now i have areally silly problem. One of the worksheets holds a list or translations i need to input into a system in the office and it is 5 pages long when printing.
I want the first 4 pages to print in portrait but the last one in landscape buit cant think how to do it. I know it is easy over worksheets but i want all this info on one worksheet.
I have a sheet in an excel workbook which I export to a separate file and then save as a text document, I need to remove the tabs in this file, however the file (example attached) needs to be in a certain format to be imported into a piece of equipment which has a proprietary file format. Part of this format is the 2nd row and 5th row must remain present and empty.
I lost the formatting in a 6 page spreadsheet. It repeated the top row, much as a header. I constantly delete and add rows, so it was nice to have the row in place as I scroll. It was better than freeze pane.
Iíve created a worksheet containing many drop down lists that form an inventory of household effects. Once selected, Iíd like to be able to view/print the selected options and quantities separately on one A4 page.
I donít want the separately viewed/ printed page to contain anything other than the selected options. The problem Iím having is to arrange this new page as a contiguous list.
I printed my graph after editing it while in normal view. It did not appear on paper like it looked on the screen. I switched to page break preview to see if I could see the problem and noticed that the printed version matched the page break version. I am using text boxes for some of my data on the graph itself, and the boxes, moreso than the bars, appear differently between views. This has never happened before, and I print this graph every month after changing the parameters and data. To my knowledge, I did not change anything out of the ordinary.
I'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.
I have headings across the sheet "Inventory" in cells E5:AA5 with further headings down the sheet D6:D40.Data Validation drop down list is in cells E6:AA40.I want to be able to place a number 1 or number 2 in any cell in the range C6:C40 in the "inventory" sheet and with a macro create 2 new sheets.Sheet 1 will contain all the headings which had a 1 in any of the cells in the range C6:C40 and sheet 2 will have all the headings which had the number 2 from the range C6:40.Both sheets 1 & 2 will contain all the headings from "Inventory" sheet in cells E5:AA5.The data validation drop down list is not required in sheets 1 and 2 but if "inventory" sheet does get updated that it also updates sheet 1 and sheet 2.... Version i am using is Excel 2010
I have an excel document with about 7 worksheets in it. The users of these worksheets can save the document but they never save it with the page view starting from the top. How can i ensure that whenever this document is open the default view for all the contained worksheets is at the top (ie:cell a1).
I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:
Option Explicit Const sName1 As String = "Lisa" Const sName2 As String = "Philip" Const sPw1 As String = "update"
Dim sPW As String, sUser As String Dim sMsg As String, sTitle As String, sStyle As String Dim iCounta As Integer Private Sub cmbValidate_Click() sTitle = "Incorrect Password"...........
I have a workbook that is setup with headers and footers. To the right, left, and below the worksheet there are other pages greyed out pages that are not being used. Is there a way to change the view and potentially remove these "other sheets?"
What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.
Below is my code which is made for a sample workbook. I was just trying to get the concept down and then i would convert it to the real workbook.
I have written a short piece of code based on some other posts and for some reason it doesn't work and it's driving me mad. The task seems to be very easy - I'm trying to get rid of some formulas in all worksheets and keep the actual values only. The part that is failing is the following: ws.Range("A1:P31").Select
When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.
I have an 6 sheet excel workbook that generates 27 additional sheets upon an executed macro. I am trying to page setup the additonal 27 sheets only to a zoom of 90. Here is what I have so far but this zooms all 33 sheets.
HTML Sub zoom_2() Application.ScreenUpdating = False
Dim wk As Worksheet For Each wk In ThisWorkbook.Worksheets wk.Activate With ActiveSheet.PageSetup .zoom = 90 End With Range("A1").Select Next wk Sheets("data").Activate End Sub
I've been using excel sheets to create reports for clients based on various sized samples of bars (I'm a test engineer). The sheets are essentially the same format though information will vary (such as bar type, diameter, etc.) I've been working on automating these sheets so that I don't need so many template-like tabs (currently I have a workbook for each client setup with 5-20 different sheets just in case the client sends in those bars! Half of the sheets stay blank and it can be confusing/cluttered).
Here's what I want to do: Have one page or popup window where I can input the information (job number, bar size, bar type, etc.) press the magic button and have it spit out a new sheet with that info added into the template. Is this doable?? I've never used macros before but I'm assuming I'll need to, which is fine, how that works.
I have data in two sheets. None of the sheets the rows and columns are fixed. I want to copy the data from the two sheets and paste it in the third sheet. I have attached a sample sheet for reference. I need to set it in page width so that I can print that.
I am trying to find a way to print an "entire workbook", but have each of the sheets paged as a group separate from the rest. One workbook typically has up to 20 sheets, with each sheet up to roughly 8 pages. I need each sheet set to show page 1 of 8 or page 5 of 8, not page 22 of 53. Counting and typing in the total number of pages in each sheet's footer is too cumbersome. Also, printing each sheet individually has also been cumbersome when printing to PDF. Are there any other ways to have the "&[Pages]" function only reflect the number of pages within the sheet instead of in the entire workbook?
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
I have some code that parses an html table. I want to put in error handling in case the format of the page changes or the internet page is unavailable. I am testing without an internet connection and the run time error is not being branched off to the error handler and is fatally ending the macro. This is true also if I raise an error manually.
Private Sub ParseInjuryPage() On Error Goto ErrorHandl Dim strPage As String Dim webIE As SHDocVw.InternetExplorer Dim myURL As String Dim tableBeg As Long Dim tableEnd As Long Dim RowBeg As Long Dim rowEnd As Long Dim cellBeg As Long Dim cellEnd As Long Dim strBeg As Long Dim strEnd As Long Dim myCell As Range Dim rowNum As Integer With Sheets("INJ") Set myCell = .Range("A2") .Range("A:F").Value = vbNullString rowNum = 2 Set webIE = New SHDocVw.InternetExplorer myURL = "http://www.sportsline.com/nfl/injuries" webIE.Navigate myURL Do Until webIE.ReadyState = READYSTATE_COMPLETE DoEvents Loop strPage = webIE.Document.body.innerhtml...................................