+ Reply to Thread
Results 1 to 36 of 36

Comment boxes collapse?

  1. #1
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Comment boxes collapse?

    my comment pop-up rectangular boxes regularly collapse to almost one dimensional [ie] a rectangle with maybe 1/32 inch width and undiminished original length?
    thus no comment box text is visible.

    ANY advise, etc. will be much appreciated.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    using VBA, cause you would need to trigger it?


    Please Login or Register  to view this content.
    one to make small one to make big
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    many thanks humdingaling.
    however I don't understand the VBA concept and don't have the time to self-educate.
    if, with directions, it is easy to implement, please link me to those directions. otherwise I will
    contract it out because I really need my comment boxes.

  4. #4
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    http://answers.microsoft.com/en-us/o...6-b7b6fd8db781
    people at this link say the problem has been with excel forever, yet it has gone unfixed by Microsoft

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    essentially i think you only want the enlarge one by the sounds of things
    http://office.microsoft.com/en-au/ex...102174076.aspx

    here is how it move macro onto your personal computer
    alternatively i have attached workbook with macro in it already

    the only other thing would be to know how to run macros
    http://www.dummies.com/how-to/conten...010-macro.html
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    many many thanks ... again. really helpful. I am busy with other tasks but will surely get to it soon.

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    not a problem
    i will remain subscribed for some time so if you have issues with it just reply to thread

    Cheers
    Hum

  8. #8
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    Quote Originally Posted by humdingaling View Post
    essentially i think you only want the enlarge one by the sounds of things
    http://office.microsoft.com/en-au/ex...102174076.aspx

    here is how it move macro onto your personal computer
    alternatively i have attached workbook with macro in it already
    hello again humdingaling in sydney

    the only other thing would be to know how to run macros
    http://www.dummies.com/how-to/conten...010-macro.html
    --------------------------------------------------

    I’m having trouble implementing this. [I have excel 2013] [e.g.] google search help
    documents describe how to show the excel developer tab
    [they say for excel 2010 & 2013] but what I see doesn’t match what they say.

    I want to be as certain as possible that I am stumbling along on the right path so......
    will the easiest way to start implementing the macro be the following;
    download the attached workbook with the macro already in it.
    follow the directions in the http://office.microsoft.com/en-au/ex...102174076.aspx link you provided
    [ie] ‘’Copy your macros to a Personal Macro Workbook’’

  9. #9
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    hi again humdingaling in Sydney.

    on second thought I think I will have a contract programmer do this for me.
    do you do that or can you refer me to someone who does?

    thanks again. your detailed help has been superb.

  10. #10
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    sorry your profile said excel 2007 so i gave you link for 2007

    Ron De Bruin gives examples for all excel versions
    http://www.rondebruin.nl/win/personal.htm

    Don't think this macro is complex enough to warrant contract programmer
    maybe youtube can help you with step by step
    https://www.youtube.com/watch?v=8Lj3NaWLzOY


    Re: contract programmer
    no idea, I'm here in Australia

    ps have a quick view of the youtube clip
    i think you will be able to follow it relatively easily - its 2013 so things will look familiar

  11. #11
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    the macro and the video that you sent were what I needed. nice job.
    after some stumbles I think I have it almost working.
    attached is an image for a ‘’run time error 1004’’ and the image which popped
    up when I clicked on the ‘’debug’’ button.
    please advise … and thanks loads for the help.

  12. #12
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    I don't think anything got attached in my previous try.
    here is another attempt.

  13. #13
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    still no attachments. they are jpg and I have done it before?
    the attachments were...

    IMAGE #1
    run time error '1004'
    Method 'Left' of object '_Application' failed

    so then I clicked on the debug button which resulted in
    IMAGE#2 which was an image of the
    the 5 lines of macro code.
    the middle line was hightlited yellow and read
    ''Application.Left = 595.75''

  14. #14
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    hmm...my code does not have .left in it?

    if the error in some other code?

  15. #15
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    I just tried to attach files via "go advanced" but I didn't see any indication that they had been attached.
    as I remember now, I must go via "go advanced" to attach...is that correct?
    I also think I remember being able to tell if the attachment has been successful...is that correct?
    I have attached files in the past, gotta be able to do it again.
    any suggestions?

  16. #16
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    I found the following in FAQ but now I can't find the 'Post Reply' button?

    How do I attach a file to a post?
    To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.
    On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.
    To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.
    Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

  17. #17
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    go advanced
    manage attachments
    +add files
    another window should open up
    select files
    upload files
    once completed
    window should close

    click done
    you should see the file under the manage attachments sections

    after this click submit reply

  18. #18
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    after much experimentation I realized there was something wrong with the two images saved by my image capturing
    program... with no indication of a problem. very mysterious?

    anyhow I resaved the images and now everything works ok.

    images are attached [I hope.
    Attached Images Attached Images

  19. #19
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    hmmmm thats not the code i sent you?

    check post #2 for the code

  20. #20
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    I downloaded the macro from the forum with the same wrong result so clearly
    I’m doing something wrong [ie] I don’t understand the excel macro concept
    logical design well enough yet.

    please tell me what I should do after downloading the macro from this thread…and
    please don’t hesitate to quit responding to my posts at any time. I will completely
    understand.

    although the code is presented in post #2 I have not messed with it, expecting the
    code to be contained in the downloaded macro?

  21. #21
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comment boxes collapse?

    An alternative, possibly:

    Please Login or Register  to view this content.
    Copy the code from the post

    In Excel, do Alt+F11 to open the VBE

    Do Insert > Module, and paste the code in the window that opens

    Do Alt+Q to return to Excel

    Do Alt+F8 to open the Macros dialog, select JoeM from the list, and press Run.
    Entia non sunt multiplicanda sine necessitate

  22. #22
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    Alt+F11 didn't do anything at first but when I happened to press them simultaneously I got what was probably the VBE.
    I didn't see any insert module path nor when I right clicked I saw no insert choice in the drop down panel?
    and I do have excel 2013.
    I sure wish Microsoft would make all this unnecessary! but it is what it is.
    also Alt+Q did nothing?
    Last edited by Joe Miller; 09-01-2014 at 03:42 PM.

  23. #23
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comment boxes collapse?

    Insert is on the main menu bar in the VBE.

  24. #24
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    I think it's working!!!!!!!!!!!!!!!

    however, when I try to save it a nasty message pops up saying
    ''VB project cannot be saved in macro-free workbooks. to save a
    file with these features, click no, and then choose a macro-enabled
    file type in the file type list''

    what should I do now. I am not going to do anything right now because
    I don't want to lose what I have so far apparently not screwed up.

  25. #25
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comment boxes collapse?

    Select Excel Macro-Enabled Workbook (*.xlsm) from the dropdown.

  26. #26
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    it's all working now. many thanks again to both you guys.
    still can't believe your patience and time spent with me.

    is there a way to have the macro run automatically at start up rather than
    doing an explicit Alt+F8, select Macros dialog, select JoeM and press Run?

  27. #27
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    it is done under a triggered event macro
    step by step instructions found here
    http://office.microsoft.com/en-au/ex...001034628.aspx

    you can do it every time you open any workbook
    instructions found under
    Creating an Auto_Open macro

    or anytime you open a specific workbook
    instructions found under
    Creating a VBA procedure for the Open event of workbook

    sorry if i am giving you too many links but i don't like to copy and paste bulks of other peoples work without acknowledging their work
    Last edited by humdingaling; 09-01-2014 at 07:51 PM. Reason: i learnt something new =)

  28. #28
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comment boxes collapse?

    Post back if you don't have it sorted.

  29. #29
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    EVERYTHING WORKING NICELY.

    ONE LAST CONCERN...I HAVE NOT BEEN ABLE TO VERIFY THAT PERSONAL.XLSB IS HIDDEN.
    I GUESS MAYBE MY PROBLEM IS IT'S VBA INSTEAD OF LOOKING LIKE A SPEADSHEET?

    RE: ''sorry if i am giving you too many links'' ... THE LINKS ARE JUST FINE AND MUCH APPRECIATED.

  30. #30
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    another problem---
    i have another excel macro enabled spreadsheet. when i click on alt-F8, when the macro window
    pops up all ''click-on'' buttons are muted. i was expecting otherwise because my understanding is
    that the personal.xlsb workbook is always available in all workbooks?
    please advise

  31. #31
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    your queries on Personal.xlsb should be answered here
    http://www.rondebruin.nl/win/personal.htm

    basically yes personal.xlsb should open every time you open excel
    yes its hidden

    hmmm muted buttons not sure
    have not come across this before

  32. #32
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    attachments #1 and #2 demonstrate that the macro is accessible for use in the workbook
    we have been discussing in this tread.

    attachment #3 shows what happens when I try to use the macro in a brand new workbook.
    all fields are muted making the macro unusable?

    the new workbook is .xlsm and macros are enabled.

    please offer thoughts, etc.
    Attached Images Attached Images

  33. #33
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    that looks like you have no saved the macro into your personal.xlsb file or maybe it has not been created
    as the macro code is in the workbook itself

    do the section on Ron's website
    How do you create the file if it does not exist:

    and then see if you can see macro under personal
    if you can then you probably did not save last time you closed excel

  34. #34
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    my perception of this is:

    in post #32....
    attachment #1 says that personal.xlsb exists.
    attachment #2 displays the correct vba code to be in personal.xlsb
    so if personal.xlsb is automatically available in all workbooks, why is in not available in the second newly created workbook?

  35. #35
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Comment boxes collapse?

    sorry delay...went away for the weekend

    Attachment 1 shows personal.xlsb exist but there is no macro there
    which is why i eluded to
    you have no saved the macro into your personal.xlsb file

    attachment #2 actually confirmed the code is not in personal.xlsb

    if you have saved into personal.xlsb it should look like this the attachment i added
    Attached Images Attached Images

  36. #36
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: Comment boxes collapse?

    delay is not a problem.... great help resources must be treated gently and with respect.
    no hurry anyhow. I will play around with this within the next few days. busy with something
    else at the moment
    thanks again
    just tried to add to your reputation again but they say I have to spread it around first.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy contents of multiple comment boxes and paste in a single comment box
    By xxJaRxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2014, 12:39 PM
  2. How to collapse radio buttons and Group Boxes and make them invisible
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 11:04 PM
  3. [SOLVED] Comment boxes collapse - excel 2007
    By Joe Miller in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-12-2012, 08:35 PM
  4. Pop up comment boxes (but not)
    By JoshuaSQ in forum Excel General
    Replies: 2
    Last Post: 05-10-2008, 02:36 PM
  5. [SOLVED] Comment Boxes
    By RWS in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 09:30 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1