Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dialog Sheet? (Excel97 SR2)

    I want to create the case changing macro as mentioned in a tip below, except I don
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    That looks like a very old macro that used a dialog sheet. If I remember correctly, dialog sheets were replaced with user forms starting with either Excel 95 or 97. You would need to use a user form and rewrite the code to work with a user form instead of a dialog sheet.
    Legare Coleman

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    I think Legare is correct - I believe your macro is from an older version of Excel than 97. Dialog Sheets last appeared in Excel 95 (thank goodness- really!). You might want to look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=51226&Search= true&Forum=xl&Words=&Match=StarPost&Searchpage=0&L imit=25&Old=allposts&Main=51219>this post </A> here. I know the thread references Excel 2K - but I believe that it will work for Excel 97 as well. If you want a different approach than Brooke's just continue further down the thread. I offered a variation on Brooke's that will toggle the selected cells from one case to another. Brooke and Legare also discuss how to setup the macro in Excel - and these instructions will also apply in Excel 97.
    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    I think this is what you need (an ancient XL5 add in, working perfectly).
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Dialog sheets are still available in XL97 and XL2K (not sure of XL XP):

    rightclick a tab, Insert, MS Excel 5.0 dialog.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Jan,
    Thanks for the add in - and you are correct! It works great! Now I want to know HOW it works. I know that an XLA file goes in the Microsoft "Library" and when you put your file there and open Excel the toolbar for changing case is there. But how can I SEE the code that makes it work?

    TIA
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  7. #7
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Jan,

    If this is your own work, would you mind telling me how you have achieved a greater level of security than MS apply to their own XL5 addins? And if it isn't, would you mind sharing it's provenance?

    Please feel free to refuse such a rude question.

    Brooke

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Sherry, Brooke,

    The utility is not mine.
    Here is the full version, I just included the XLA last time.

    I got this from:
    http://go.compuserve.com/MSOfficeForum

    Dunno about the security part, all I can say is that this is what one gets when one has created the addin in XL5: the project becomes unviewable.
    Attached Files Attached Files
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Jan,

    thankyou.

    Not all XL5 XLA's are unviewable. if you try to access, for instance, autosave, instead of the unviewable message you get a password box. I was just wondering how you'd managed to make it unviewable. Still, never mind!

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    Hi Brooke,

    <<I was just wondering how you'd managed to make it unviewable.>>

    I haven't, not my project. I can ask around if you like though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    thanks for the offer, but only if it doesn't put you out - my curiosity was merely of the idle kind.

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    You are of course, right. As soon as I could work in the VB editor - I went there. Does anyone have any thoughts on comparing a dialog sheet with the VB editor?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  13. #13
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    But aren't you our resident xl5 genius? or am I thinking of someone else. I never used macro sheets - I woke up to find VBA, and can't begin to code one up, though I can start to see what is going on in one on a good day - although I don't actually come across it, but despite this I do sometimes wonder whether it would be worth my learning. If autosave (at least up to 2k) is the same beast as it was way back when. Are there reasons for that? and old isn't neccesarily bad - I spent a little while tryin to fathom GET & SET for use in defined names as the result of a post here much earlier in the year, and although I didn't get far, it is a project on the back burner to find out which version of excel those commands come from, get hold of a copy, install it on an old machine and start ploughing through the help files.

    And so my view is that whilst I believe the VBE is an easier place to work, I do sometimes wonder whether we've lost any functionality?

  14. #14
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    But aren't you our resident xl5 genius?
    No, please no! <img src=/S/confused.gif border=0 alt=confused width=15 height=20> <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15> <img src=/S/shocked.gif border=0 alt=shocked width=15 height=15> You are confusing the fact that I have been forced to work in xl5 recently, with expertise. I hope you've noted the correlation between those times and the number of questions I've been forced to post. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    However, I do think your question - ...whilst I believe the VBE is an easier place to work, I do sometimes wonder whether we've lost any functionality? is an interesting one.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  15. #15
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dialog Sheet? (Excel97 SR2)

    bang goes my weekend - but thank you for the link!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •