+ Reply to Thread
Results 1 to 10 of 10

How do we add the minimize and maximize functionality

  1. #1
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    How do we add the minimize and maximize functionality

    Hi friends,

    i am using excel 2003.

    i have put a attachement to this post.

    please open it and you can see + or - symbols in the very left side.

    if we click them the rows are minimized and maximized accordingly.

    How do we achieve that functionality?

    i see no macros in that document.
    i got this document from one of my friends.
    how can we do that?
    do we need to insert any object or specify any property like that?


    thank you
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    67

    Re: How do we add the minimize and maximize functionality

    Data-Group and Outline-Group
    to group the selected rows
    and Data-Group and Outline-Ungroup
    to ungroup the selected grouped rows

  3. #3
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: How do we add the minimize and maximize functionality

    many thanks,

    now i can play around that functionaliy

    thank you

  4. #4
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: How do we add the minimize and maximize functionality

    well... one more question, don't mind please


    you can see a field with the name "Updation Date" in that document.

    My requirement is that if we make any changes in a row, the cell content of the field "Updation Date" in that row must be updated with the the current date.

    so how can we capture that the cells have been changed?
    and how can we set the field with the current date?


    thank you

  5. #5
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: How do we add the minimize and maximize functionality

    Hi there,

    The following code should work for your request. It checks to see if a change was made in columns D:L, and if so it then checks to see if there is a value in column A (based on your sample data, the rows that have dates don't have a value in column A).

    If no value exists, it then updates column M of that row to the current date.
    Please Login or Register  to view this content.
    If you need to protect that date cell so users can't edit it manually, you could protect the worksheet with a password (unlock any cells you want the users to be able to edit, first) and then add a couple lines of code to unprotect and then re-protect the sheet after the date is updated.

    Hope that helps!

  6. #6
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: How do we add the minimize and maximize functionality

    Many thanks, it worked perfectly

  7. #7
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: How do we add the minimize and maximize functionality

    hi there pjoaquin,

    i have a problem here that, Suppose if we change the headings of the fields(ex balance,payment done etc), then also the field name "Updation Date" itself is changing.
    can we avoid it?


    thank you

  8. #8
    Registered User
    Join Date
    02-26-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: How do we add the minimize and maximize functionality

    hi there c_m,

    Group and outline functionality is not working if the document is Protected.
    Is there any alternative?


    thank you

  9. #9
    Registered User
    Join Date
    08-08-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: How do we add the minimize and maximize functionality

    i want to maximise and minimise function inside the excel sheet

  10. #10
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,146

    Re: How do we add the minimize and maximize functionality

    ismail,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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