excel07

  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.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top