$$Excel-Macros$$ Printing Word and Excel documents via VBA

2011-07-06 Thread crossy75
Hi there i have 2 questions Firstly how do i attach a file to these posts? i cant see anywhere to show people my problem? Secondly: i have a word document which needs excel pages putting in it - i need a macro to: print page 1 of c:\xx\document1.doc print page1 of sheet1 of c:\yy\excelwkbk1.xls

$$Excel-Macros$$ Pivot table - show pages as individual workbooks

2011-06-30 Thread crossy75
Hello again - and thanks for the last response, you guys are ace! right have now taken a lot of data relating to clients and have a pivot table, which when i show pages lists 30 worksheets with each one being a separate client and valuation. Is there a way instead of showing the pages as individu

$$Excel-Macros$$ Disable specific macro's and functions

2011-06-27 Thread crossy75
I have this bit of code in a spreadsheet - it is used with a formula to count the number of visible rows. This is useful in accounts where people hid things thus counting what you see isnt always what you get! 'Function Vis(Rin As Range) As Range 'Returns the subset of Rin that is visible