Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cosmogramma

    Using VBA to assign a macro to a button

    BINGO!!! Thanks! It gave me some kind of error about not having Button1_Click, but I just ranamed the Print code and it worked. Is Button1_Click a specific method I need to assign code, or were you just using that as an example of what my code could be named?
  2. cosmogramma

    Using VBA to assign a macro to a button

    I've tried breaking it up into a couple of statements newWbk.VBProject.VBComponents.Import("W:\XXXX\Module1.bas") newWbk.Sheets(outShtName).Shapes("Button 1").Select Selection.OnAction = "PrintFormatted" When I single step through it, the Import of the module works fine, and selecting Button 1...
  3. cosmogramma

    Excel - How to Include Multiple columns on every page

    Hey everyone, I resolved my printing problem. Turns out I don't have to make it my fulltime job to print this because there's a great function in VBA called HPagebreaks. Since I know my spreadsheet will always be 4 Pages accross and ?? pages down, I can use a function like this to determine...
  4. cosmogramma

    Using VBA to assign a macro to a button

    I'm not sure what you mean by something in the code. I know that when I do get the new spreadsheet, and send it to another machine that button still referances the template code. When you right click and reassign the Printing Macro to the button, it works fine. So the macro is being imported...
  5. cosmogramma

    Using VBA to assign a macro to a button

    I posted a few days ago about an Excel template I've created. The template creates several new excel spreadsheets with data for different users, and I wish to transfer a button and a print formatting macro to these sheets. In my code I have the following two statements to import the Module...
  6. cosmogramma

    Excel - How to Include Multiple columns on every page

    It does matter if I print them in order. If a user has a 30 page spreadsheet to print out, they need those pages appear in the correct order. I believe I've solved the problem of getting everything to print properly, I just can't get it to stop in any nice way. I have an if statement within a...
  7. cosmogramma

    Excel - How to Include Multiple columns on every page

    Not exactly. These spreadsheets are about 4 pages accross, and an undetermined number of rows. So page 5, page 9 and page 13, etc, need to behave like Page 1. (I am printing ACCROSS and DOWN.) Every time the leftmost page is printed those columns need to be exposed. For the other 3 pages...
  8. cosmogramma

    Excel - How to Include Multiple columns on every page

    Wow. Can't tell you how helpful these various suggestions have been. What I'm down to now, is a separate PrintFormatting macro that is transfered to each of the Workbooks I'm generating. This macro Prints the spreadsheet accross and down as follows: -Prints page 1 -Hides columns -Prints...
  9. cosmogramma

    Excel - How to Include Multiple columns on every page

    I'm not sure I understand this solution. My template Excel file will generate 20 or 30 spreadsheets (all separate Excel files), which will then be distributed to people. These newly generated files do not contain any of the macros the original Template file. How can I ensure that in my...
  10. cosmogramma

    Excel - How to Include Multiple columns on every page

    Related question: I have this macro below that prints the first few pages. How do I automate the transfer of this macro (and an associated button) into the new spreadsheets I'm generating and sending out to people? Sub RecordingPrintingAgain() ActiveWindow.SelectedSheets.PrintOut From:=1...
  11. cosmogramma

    Excel - How to Include Multiple columns on every page

    Ok. I'll have to investigate the Print using a button option. I appreciate the input. Thanks.
  12. cosmogramma

    Excel - How to Include Multiple columns on every page

    Agreed. A ridiculous requirement even. The users need this to be in Excel, as a regular spreadsheet they can edit. There are a larege number of columns so there are several pages across, and many more down. The first page needs to display all of the information, but the remaining pages only...
  13. cosmogramma

    Excel - How to Include Multiple columns on every page

    ...what if I'm unable to move the C&D data to H&I? Is this just impossible to do?
  14. cosmogramma

    Excel - How to Include Multiple columns on every page

    Hello I'm generating some excel spreadsheets using VBA to specify page setup. Is there a way that I can include columns A, B, H and I on every page. Example: Page 1 [Columns A-N] Page 2 [A,B,H,I,O-X] Page 3 [A,B,H,I,Y-AI] Page 4 [A,B,H,I, etc] I'm really hoping someone can point me in the...

Part and Inventory Search

Back
Top