Search:

Type: Posts; User: Ivan F Moala; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.14 seconds.

  1. Replies
    4
    Views
    687

    Re: Right Click Menu on Sheet name

    Glad you got this resolved, thanks for letting us know.
  2. Replies
    8
    Views
    868

    Re: Workbook Event on Sheet Deletion

    Yes can can Simulate this!

    Place in ThisWorkBook code Module



    Option Explicit
    '// http://www.xtremevbtalk.com/showthread.php?t=147139
    Dim shName As String
  3. Replies
    6
    Views
    345

    Re: Help to Understand VBA

    Also, try highlighting a Key word and Press F1 (Help) .... that coupled with what you read hear may help you understand further.
  4. Replies
    13
    Views
    1,996

    Re: Hyperlinking to PDF documents

    Use it like this...



    strPrgm = fnGetExePath(".pdf")


    There are shorter ways to get the Path, but use this any way.
  5. Replies
    1
    Views
    311

    Re: Refer to Clicked Object

    if you are selecting the Chart then try something like



    ActiveSheet.Shapes(Application.Caller).Select


    generally not good to select objects... but try this any way
  6. Replies
    13
    Views
    1,996

    Re: Hyperlinking to PDF documents

    Hi James

    To get the users Adobe path
    Have a look @ the write up I did here

    http://www.dailydoseofexcel.com/archives/2005/07/29/get-executable-path/
  7. Re: Calling a Command Prompt to execute user defined actions

    Look in the other thread you started concerning PDF
  8. Replies
    13
    Views
    1,996

    Re: Hyperlinking to PDF documents

    As for your last Q, there are a number of ways ....

    I'll give you the easiest, although it is not what I would use as it hard codes the Adobe program location.



    Sub ShellPDF()
    '// Opens PDF...
  9. Replies
    13
    Views
    1,996

    Re: Hyperlinking to PDF documents

    try

    fPath = ThisWorkbook.Path & Application.PathSeparator
  10. Replies
    13
    Views
    1,996

    Re: Hyperlinking to PDF documents

    If workbook and PDFs in same Dir then Use

    fPath = ThisWorkbook.Path

    To get the Path.
  11. Re: how to use inbuilt functions in macro

    Also have a look @

    Application.WorksheetFunction
  12. Re: how to jump out of a continuously running process?

    Hi Tarheel1

    What do you curently have as your code
  13. Re: Run time error '91' while performing a "Find"

    try

    LookIn:=xlFormulas
  14. Replies
    4
    Views
    524

    Re: Cell value = Sheet name

    The function =CELL("filename",A1)
    will return something like > C:\DirectoryName\[WorkBookName.xls]SheetName
    which is the full path of the current workbook. Enclosed within [ ] is the WorkBook name...
  15. Replies
    4
    Views
    524

    Re: Cell value = Sheet name

    one of many ways

    =MID(CELL("filename",A1),FIND("]",CELL("filename"),1)+1,255)
  16. Re: VB Error on Opening; possibly on Userform

    Thanks for posting back Deborah and glad you found it. Always good when you solve it yourself.
  17. Replies
    3
    Views
    845

    Re: Folder name in different color.

    Folder names get changed to blue if they are compressed. You do this via properties advanced > compress folder.
  18. Re: Pasting Excel (as a Worksheet Object) in PowerPoint

    What do you get when you double click the Excel object ?
    There maybe slight chance that the spreadsheet is not displayed in the region you wanted ?
    i.e. double clciking should take you into Edit...
  19. Re: VBA - Determining what radio button is selected

    Assign code to button .... resets all Optionbuttons


    Dim sh As Shape

    For Each sh In ActiveSheet.Shapes
    If sh.FormControlType = xlOptionButton Then
    sh.OLEFormat.Object.Value =...
  20. Re: opening a workbook with a command button

    You can always hide the workbook....



    Private Sub CommandButton1_Click()
    '
    ' OpenABC Macro
    ' Macro recorded 21/04/2009 by martin.lucas
    '
    ' Keyboard Shortcut: Ctrl+Shift+M
  21. Replies
    3
    Views
    2,362

    Re: Animated GIF progress bar not working.

    No problem .....
  22. Replies
    12
    Views
    723

    Re: accidently added a macro

    In your image above, Delete all that text on the right Pane = WorkSheet_Selectionchange ....
  23. Replies
    10
    Views
    1,180

    Re: Auto_open in an .xla

    If you do use Workbook open event of the Addin, which should work, then also put in the reset code to disable it in the Addinuninstall event other wise the double click event will always call this...
  24. Replies
    3
    Views
    2,362

    Re: Animated GIF progress bar not working.

    Animated gifs will not display animation in a std picture box.
    You either need an ActiveX dll, picture swapping or a browser control.

    To use the webbrowser control see here
    ...
  25. Replies
    4
    Views
    334

    Re: Duplicate formula not working

    perhaps ??

    {=IF(COUNTA(Rng)-SUM(COUNTIF(Rng,Rng)/IF(NOT(COUNTIF(Rng,Rng)),1,COUNTIF(Rng,Rng))^2)>0,"Duplicates","")}

    where Rng = $F11:O11
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4