excel07

I have the following code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.DisplayAlerts = False Dim StrPath Select Case Range("M5").Value Case "" StrPath = "S:\Approved blank admin forms\" Case "Tommy" StrPath = "Z:\" Case...

I have a workbook with 3 worksheets in it. Each worksheet needs a various number of duplicate pages. In other words, the info on the page is like a template that needs to be copied downward. The page contains formulas and a macro attached to a button. I have the Workbook created, with 1 page...

Hi, I am trying to record a simple macro ... a simple repetitive task (moving and removing cells) which I would like to be applied over a whole spreadsheet. So I record several repetitive steps of the macro and then I try to run the macro in the actual spreadsheet. The result is that the macro...

It doesn't appear that Excel 2007 allows tables to have calculated headings. I'd like to have a heading be a variable that can change when another cell changes and it appears that the functionality is no longer available. Am I missing something? Any help would be most appreciated.