Search:

Type: Posts; User: whippler; Keyword(s):

Search: Search took 0.00 seconds.

  1. Macro help: Paste (special metafile picture) from excel to ppt slide

    i have a deck of slides...1 chart from excel on each slide...I want to create a macro that takes a chart that i already copy in excel, then in ppt enviornment:

    1. deletes 'old' chart already on...
  2. URGENT HELP NEEDED - TURNING LIST FROM ONE CELL INTO

    SEPARATE ROWS.

    IS THERE A FXN OR MACRO TO TAKE A COPIED OUTLOOK DISTRIBUTION (USING SEMI COLONS) INTO SEPARATE ROWS AS OPPOSED TO ONE CELL IN EXCEL?
  3. prompt

    i need to know how to bring up the password prompt for user entry when executing a macro that needs to unlock the sheet (it unhides columns)

    how do i do that....protecting it is easy
  4. macro for protect/unprotect that prompts for password!!!!

    i have a workbook that admin users will be using...i have the book locked for regular users, but i have some buttons that the admins will click to unhide certain information...how can i set the...
  5. Replies
    3
    Views
    513

    Re: Sort in a protected sheet

    thanks, i've done that before, got it
  6. Replies
    3
    Views
    513

    Sort in a protected sheet

    Is there a way than I can protect a sheet, and still enable the end user to be able to sort an array of data?
  7. Replies
    3
    Views
    495

    Re: Nested Conditions

    duh, thanks!
  8. Replies
    3
    Views
    495

    Nested Conditions

    I have a dynamic table below, and I want the last column to display one of four things based on the third column:

    geo a b
    north 7.5 0.1 FALSE
    south 9.4 0.4
    west 7.0 0.3
    central 6.9 -0.1 ...
  9. Replies
    2
    Views
    530

    Scenario: 1. 6 separate PPTs have ~18 slides...

    Scenario:

    1. 6 separate PPTs have ~18 slides each.
    2. Each slide has a chart and title that link to two
    different Excel files.
    3. Each week both Excel files are automated to pull in a
    large...
  10. Replies
    2
    Views
    530

    hey everyone i have a PowerPoint link to Excel...

    hey everyone

    i have a PowerPoint link to Excel issue that no one has been able to figure out here at home, or on the MS Power Point "communities" message board.

    Shall I post??.......its not...
  11. Replies
    2
    Views
    2,309

    perfect! thank you

    perfect!

    thank you
  12. Replies
    2
    Views
    2,309

    First time using Colo's utility, may have messed...

    First time using Colo's utility, may have messed up. Anyway, each week, this sheet is populated with new data, it is a rolling 13 week set, so next week it will start with week of 9/13, and a new...
  13. thank you!

    thank you!
  14. When I execute this macro in a file, there are 37...

    When I execute this macro in a file, there are 37 instances of this:

    Application.ScreenUpdating = False

    Workbooks.Open(FileName:= _
    ...
  15. Replies
    3
    Views
    41,951

    I have a template that pulls in data from 37...

    I have a template that pulls in data from 37 other workbooks each week and calculates info with charts. My macro does not close all of the 37 workbooks automatically b/c each book prompts for "save...
Results 1 to 15 of 15