1. ErinJ

    excel beforesave function

    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...
  2. motherteresa

    Copy and Paste Macro

    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...
  3. J

    macros - help needed

    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...
  4. S

    Calculated Table Headings in Excel 2007

    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.

Some videos you may like

This Week's Hot Topics