Programming

AutoFit macro that will not affect the header row?
I've tried: Selection.Rows.AutoFit and ActiveSheet.Rows.AutoFit Selection.Rows.AutoFit only affects the active row one is on, which is not enough. But the ActiveSheet one affects the entire sheet, which would be okay if there were no header row. Is there a way to get the macro fine-tuned to ignore the heade... 17 Jul 2008 14:46

Make function available to all workbooks?
Hi, I have a workbook which (via code) copies one of the worksheets into a new workbook. The copied worksheet contains cell formulas using a function in the original workbook. When copied, the new worksheet returns a #NAME?# error in the cells using the function. Can I make the function available to all ope... 16 Jul 2008 21:18

Basic Security via PDL
Hi, I'm trying to add some basic security to a workbook, but which will check if the user (via Application.UserName) exists in an Exchange PDL, and if it does, then give them access This is a template workbook and therefore saved thousands of times as different file names... I need the PDL check to run live... 17 Jul 2008 01:24

checkbox help needed
1. i got 4 checkbox in a frame. when a user click commandbutton1 i need it to check if checkbox1.value = true then print sheet1 if checkbox2.value = true then print sheet2 etc through to checkbox4 2. when user click commandbutton2 i need it to check if textbox1.value = "user2". if it does i need sheet6 unp... 16 Jul 2008 19:15

finding data across multiple ws to populate a userform (Need Help)
My problem is that I have a code that searches for dat on multiple pages but has multiple entries that maybe the same under the first search condition therefore my code needs to check a secondary search condition but when my code tries to do this on some pages it doesn't work. So here is how it works, I have a... 17 Jul 2008 08:34

Assign a project name to weekly hours/pay
I want to input one employee's hours/pay for each week of the year. Then in the next column associate a project name etc. for the whole year. Then at the top page(maybe frozen) I want each project name to pull only the data with its associated name (next to it) for a yearly total. ... 16 Jul 2008 19:15

deleting data but not formulae in multiple sheets
Hi I need to clear the data in 12 worksheets at once (Jan to Dec), but leave the formulae intact. Any ideas on a quick way of doing that with a macro please? Thanks Terry ... 16 Jul 2008 20:17

Hot to change the Excel File Logo (VBA Project)
Hi, I made a vba project, and I want to change the Excel File Logo (Excel File Icon). to give a professional look of my vba program. How it is possible..... If any one knows pls send me reply. Regards. Shahzad ... 16 Jul 2008 17:11

VBA code to update sheets in manual calc workbook
Hi, I have a bit of an odd problem that has been bugging me for a few days with so far no solution. I have a large workbook that needs to run in manual calculation mode where certain sheets are updated in a particular order using shift-F9. I am trying to get some code to work that when one of these sheets is ... 16 Jul 2008 17:11

Simple If Statement
I want to include an if Statement. That will look for the word Payside in the column header and if it can find it then continue with the Sub or if it can't just skip the sub. I'm not sure what i'm doing wrong. Thanks, Karl ... 16 Jul 2008 17:11